TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dipti prasad
NA
76
39.1k
jqgrid delition issue
Dec 17 2014 8:16 AM
Hello Friends,
Please help me!
I have one problem :i have 5 rows in jqgrid.in my jqgrid i set multiselect: true.
when i delete 3 rows in jqgrid at a time then my 2 rows are remaining but when i add new data in jqgrid my existing 2 rows was deleted and disply new data.Please check my below code:
[HttpGet]
public JsonResult GetRecords(string sidx, string sord, int page, int rows, bool _search)
{
List<TempLedgerBranch> test;
if (Session.Count != 0)
{
test = Session["postData"] as List<TempLedgerBranch>;
}
else
{
test = new List<TempLedgerBranch>();
}
var count = test == null ? 0 : test.Count;
int pageIndex = page;
int pageSize = rows;
int startRow = (pageIndex * pageSize) + 1;
int totalRecords = count;
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
if (test == null)
{
return Json(null, JsonRequestBehavior.AllowGet);
}
else
{
var result = new
{
total = totalPages,
page = pageIndex,
records = count,
rows = test.Select(x => new
{
x.Sno,
x.Code,
x.Branch,
x.BankCode,
SubLdgr = x.Code,
x.Debit,
x.Credit,
x.CostCentre,
ProfitCenter = x.Code,
x.Cheque,
x.Narr
}
).ToArray()
.Select(x => new
{
id = x.Sno,
cell = new string[] { x.Sno.ToString(),
x.Code,
x.Branch,
x.BankCode,
x.Code,
Convert.ToString(x.Debit),
Convert.ToString(x.Credit),
x.CostCentre,
x.Code,
x.Cheque,
x.Narr
}
}
).ToArray()
};
return Json(result, JsonRequestBehavior.AllowGet);
}
}
[AcceptVerbs(HttpVerbs.Post)]
public void EditRecords(TempLedgerBranch postData, FormCollection collection, DataTable DtTbl)
{
// if (ModelState.IsValid)
//{
try
{
List<TempLedgerBranch> test = new List<TempLedgerBranch>();
if (collection["oper"] == "edit")
{
collection.Remove("oper");
string id = collection["id"];
var EditRecord =
test.Where(x => x.Sno == id).SingleOrDefault();
test.Remove(EditRecord);
test.Add(postData);
Session["postData"] = test;
GetRecords("", "asc", 1, 100, true);
}
else if (collection["oper"] == "add" && postData.Code != null)
{
try
{
//collection.Remove("oper");
//collection.Remove("id");
postData.RecordKey = 0;
postData.UserId = "1";
postData.AccPeriod = "";
postData.Audited = true;
postData.AuthIds = "";
postData.Authorise = "";
postData.BankCode = postData.BankCode;
postData.BillDate = System.DateTime.Now;
postData.BillNo = "333";
postData.Branch = postData.Branch;
postData.Cheque = postData.Cheque;
postData.ChequeReturn = true;
postData.ChqCategory = 12;
postData.ClearDate = System.DateTime.Now;
postData.Code = postData.Code;
postData.CostCentre = postData.CostCentre;
postData.Credit = postData.Credit;
postData.CurrAmount = 124;
postData.CurrName = "Dipti";
postData.CurrRate = 154;
postData.Debit = postData.Debit;
postData.DocDate = System.DateTime.Now;
postData.HWSerial = "";
postData.MainType = "";
postData.Narr = postData.Narr;
postData.OSAdj = "";
postData.Party = "";
postData.PCCode = "";
postData.PeriodCode = "";
postData.Prefix = "";
postData.ProjectCode = "";
postData.ProjectStage = "";
postData.ProjectUnit = "";
postData.RecoFlag = "";
postData.RefDoc = "";
postData.SLCode = "";
postData.Sno = postData.Sno;
postData.Srl = "";
postData.SubType = "";
postData.TDSCode = "";
postData.TDSFlag = false;
postData.TouchValue = 1;
postData.Type = "";
postData.ValueDate = System.DateTime.Now;
postData.xBranch = "";
postData.EnteredBy = "";
postData.LastUpdateDate = System.DateTime.Now;
postData.HWSERIAL2 = "";
DataRow Drow = DtTbl.NewRow();
if (Session.Count != 0)
{
test = Session["postData"] as List<TempLedgerBranch>;
}
else
{
test = new List<TempLedgerBranch>();
}
test.Add(postData);
Session["postData"] = test;
GetRecords("", "asc", 1, 100, true);
}
catch (Exception ex)
{
Debug.WriteLine(ex.StackTrace);
}
}
else if (postData.Branch == null)
{
string[] rowid = {collection["id"]};
string csvString = string.Join(",", rowid);
foreach (var id in csvString)
{
var DeleteRecord =
test.Where(x => x.Sno == Convert.ToString(id)).SingleOrDefault();
test.Remove(DeleteRecord);
}
Session["postData"] = test;
//GetRecords("", "asc", 1, 100, true);
//ctx.SaveChanges();
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
Reply
Answers (
0
)
Popup / Tooltip to keep informed user's use of cookies
Create Pie chart using xml data