public ActionResult Edit(Models.CardPayroll.VMs model, FormCollection form) { try { ViewBag.SalaryCodeGroup_Header = dbcontext.SalaryCodeGroup_Header.Where(a => a.GroupPurpose == 1).ToList().Select(m => new { Code = m.CodeGroupID + "-----[" + m.CodeGroupDesc + ']', ID = m.ID }); ///update//// var updated_model = dbcontext.SalaryItemCollectionGroup_Header.FirstOrDefault(m => m.ID == model.SalaryItemCollectionGroup_Header.ID); updated_model.Modified_By = User.Identity.Name; updated_model.Modified_Date = DateTime.Now.Date; updated_model.CollectionDesc = model.SalaryItemCollectionGroup_Header.CollectionDesc; updated_model.CollectionAltDesc = model.SalaryItemCollectionGroup_Header.CollectionAltDesc; dbcontext.SaveChanges(); ///////////delete////////// var update_details = dbcontext.SalaryItemCollectionGroup_Detail.Where(m => m.CollectionId == updated_model.ID.ToString()).ToList(); dbcontext.SalaryItemCollectionGroup_Detail.RemoveRange(update_details); dbcontext.SaveChanges(); ///////////////////add/////// var Family_profile = form["Family_profile_No2"].Split(char.Parse(",")); var Family_name = form["Family_name"].Split(char.Parse(",")); var Percentage = form["Percentage"].Split(char.Parse(",")); for (var i = 0; i < Family_profile.Length; i++) { if (Family_profile[i] != "") { //var ID = int.Parse(Family_profile[i]); //var item = dbcontext.salary_code.FirstOrDefault(m => m.ID == ID); var new_details = new SalaryItemCollectionGroup_Detail { CollectionId = updated_model.ID.ToString(), CodeGroupID = Family_profile[i], Created_By = User.Identity.Name, Created_Date = DateTime.Now.Date, SortIndex = int.Parse(Percentage[i]), CodeGroupDescription = Family_name[i] }; dbcontext.SalaryItemCollectionGroup_Detail.Add(new_details); dbcontext.SaveChanges(); } } //////////////// return(RedirectToAction("index")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Edit(string id) { try { ViewBag.SalaryCodeGroup_Header = dbcontext.SalaryCodeGroup_Header.Where(a => a.GroupPurpose == 1).ToList().Select(m => new { Code = m.CodeGroupID + "-----[" + m.CodeGroupDesc + ']', ID = m.ID }); var ID = int.Parse(id); var old_model = dbcontext.SalaryItemCollectionGroup_Header.FirstOrDefault(m => m.ID == ID); var old_details = dbcontext.SalaryItemCollectionGroup_Detail.Where(m => m.CollectionId == old_model.ID.ToString()).ToList(); var new_model = new Models.CardPayroll.VMs { SalaryItemCollectionGroup_Detail = old_details, SalaryItemCollectionGroup_Header = old_model }; return(View(new_model)); } catch (Exception) { return(RedirectToAction("index")); } }