public ActionResult Create(FormCollection form, SalaryItemCollectionGroup_Header model) { try { ViewBag.SalaryCodeGroup_Header = dbcontext.SalaryCodeGroup_Header.Where(a => a.GroupPurpose == 1).ToList().Select(m => new { Code = m.CodeGroupID + "-----[" + m.CodeGroupDesc + ']', ID = m.ID }); if (ModelState.IsValid) { SalaryItemCollectionGroup_Header new_Record = new SalaryItemCollectionGroup_Header(); new_Record.CollectionId = model.CollectionId; new_Record.CollectionDesc = model.CollectionDesc; new_Record.CollectionAltDesc = model.CollectionAltDesc; new_Record.Created_By = User.Identity.Name; new_Record.Created_Date = DateTime.Now.Date; var Header = dbcontext.SalaryItemCollectionGroup_Header.Add(new_Record); dbcontext.SaveChanges(); 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 = Header.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")); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(string id) { ViewBag.SalaryCodeGroup_Header = dbcontext.SalaryCodeGroup_Header.Where(a => a.GroupPurpose == 1).ToList().Select(m => new { Code = m.CodeGroupID + "-----[" + m.CodeGroupDesc + ']', ID = m.ID }); var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Payroll); var model = dbcontext.SalaryItemCollectionGroup_Header.ToList(); var count = 0; if (model.Count() == 0) { count = 1; } else { var te = model.LastOrDefault().ID; count = te + 1; } var SalaryItemCollectionGroup_Header = new SalaryItemCollectionGroup_Header { CollectionId = stru.Structure_Code + count.ToString() }; return(View(SalaryItemCollectionGroup_Header)); }