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 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)); }
}
