public ActionResult create()
{
try
{
ViewBag.defaultpayrollperiod = dbcontext.PayrollPeriodSetup.ToList().Select(m => new { Code = m.PeriodCode + "-[" + m.PeriodDesc + ']', ID = m.ID }).ToList();
ViewBag.accountnumberforaccruedasallery = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID }).ToList();
ViewBag.defaultaccountnumberforaccruedpayment = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID }).ToList();
ViewBag.checktype = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-[" + m.Description + ']', ID = m.ID }).ToList();
ViewBag.deathdaysubscriptioncode = dbcontext.Subscription_Syndicate.ToList().Select(m => new { Code = m.Subscription_Code + "-[" + m.Subscription_Description + ']', ID = m.ID }).ToList();
ViewBag.Basicsallarycode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.totalexcludedallwencecode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.earnedsallarycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 1).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///earned money type
ViewBag.deductedsallerycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///deducted money type
ViewBag.Deathdaysallarycode = dbcontext.salary_code.Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList();
var recod = new PayrollGeneralSetup {
AllowToRounding = false, Length_Of_Segment = 0, Number_Of_Account_Segments = 0, Value = 0, Rest_On_The_First_Punishment = true
};
var model = new PayrollGeneralSetupVM {
PayrollGeneralSetup = recod, Rounding_method = Rounding_method.Down, ERP_INTERGRATION_TYPE = ERP_INTERGRATION_TYPE.microsoft_AX2009, GL_cost_center_distribution_behavior = GL_cost_center_distribution_behavior.primary_location_organization_behavior
};
return(View(model));
}
catch (Exception e)
{
return(RedirectToAction("index"));
}
}
public ActionResult edit(int id)
{
try
{
ViewBag.defaultpayrollperiod = dbcontext.PayrollPeriodSetup.ToList().Select(m => new { Code = m.PeriodCode + "-[" + m.PeriodDesc + ']', ID = m.ID });
ViewBag.accountnumberforaccruedasallery = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.defaultaccountnumberforaccruedpayment = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.checktype = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-[" + m.Description + ']', ID = m.ID });
ViewBag.deathdaysubscriptioncode = dbcontext.Subscription_Syndicate.ToList().Select(m => new { Code = m.Subscription_Code + "-[" + m.Subscription_Description + ']', ID = m.ID });
ViewBag.Basicsallarycode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.totalexcludedallwencecode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.earnedsallarycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 1).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///earned money type
ViewBag.deductedsallerycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///deducted money type
ViewBag.Deathdaysallarycode = dbcontext.salary_code.Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList();
var rec = dbcontext.PayrollGeneralSetup.FirstOrDefault(m => m.ID == id);
var model = new PayrollGeneralSetupVM {
PayrollGeneralSetup = rec, Rounding_method = (Rounding_method)rec.Rounding_Method, ERP_INTERGRATION_TYPE = (ERP_INTERGRATION_TYPE)rec.IntegrationType, GL_cost_center_distribution_behavior = (GL_cost_center_distribution_behavior)rec.GL_DistrbutionBehavior
};
return(View(model));
}
catch (Exception e)
{
return(RedirectToAction("index"));
}
}
public ActionResult create(PayrollGeneralSetupVM model, FormCollection form)
{
try
{
ViewBag.defaultpayrollperiod = dbcontext.PayrollPeriodSetup.ToList().Select(m => new { Code = m.PeriodCode + "-[" + m.PeriodDesc + ']', ID = m.ID });
ViewBag.accountnumberforaccruedasallery = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.defaultaccountnumberforaccruedpayment = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.checktype = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-[" + m.Description + ']', ID = m.ID });
ViewBag.deathdaysubscriptioncode = dbcontext.Subscription_Syndicate.ToList().Select(m => new { Code = m.Subscription_Code + "-[" + m.Subscription_Description + ']', ID = m.ID });
ViewBag.Basicsallarycode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.totalexcludedallwencecode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.earnedsallarycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 1).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///earned money type
ViewBag.deductedsallerycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///deducted money type
ViewBag.Deathdaysallarycode = dbcontext.salary_code.Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList();
var new_model = model.PayrollGeneralSetup;
var allow = form["check_A"].Split(',');
var PUNI = form["check_B"].Split(',');
if (allow.Length == 1)
{
new_model.AllowToRounding = false;
}
else
{
new_model.AllowToRounding = true;
}
if (PUNI[0] == "first")
{
new_model.Rest_On_The_First_Punishment = true;
new_model.Rest_On_The_Last_Punishment = false;
}
else
{
new_model.Rest_On_The_First_Punishment = false;
new_model.Rest_On_The_Last_Punishment = true;
}
new_model.Rounding_Method = Convert.ToInt16(model.Rounding_method.GetHashCode());
new_model.IntegrationType = Convert.ToInt16(model.ERP_INTERGRATION_TYPE.GetHashCode());
new_model.GL_DistrbutionBehavior = Convert.ToInt16(model.GL_cost_center_distribution_behavior.GetHashCode());
new_model.Created_By = User.Identity.Name;
new_model.Created_Date = DateTime.Now.Date;
new_model.SetupKey = 0;
if (new_model.DefaultPayrollPeriod == null || new_model.DefaultPayrollPeriod == "")
{
new_model.DefaultPayrollPeriod_des = "empty";
}
else if (int.Parse(new_model.DefaultPayrollPeriod) > 0)
{
var id_ = int.Parse(new_model.DefaultPayrollPeriod);
var dd = dbcontext.PayrollPeriodSetup.FirstOrDefault(m => m.ID == id_);
new_model.DefaultPayrollPeriod_des = dd.PeriodCode + "-" + dd.PeriodDesc;
}
else
{
new_model.DefaultPayrollPeriod_des = "empty";
}
var saved = dbcontext.PayrollGeneralSetup.Add(new_model);
dbcontext.SaveChanges();
saved.SetupKey = saved.ID;
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("payroll general setup", HR.Models.user.Action.Create, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
catch (Exception e)
{
return(View(model));
}
}
public ActionResult edit(PayrollGeneralSetupVM model, FormCollection form)
{
ViewBag.defaultpayrollperiod = dbcontext.PayrollPeriodSetup.ToList().Select(m => new { Code = m.PeriodCode + "-[" + m.PeriodDesc + ']', ID = m.ID });
ViewBag.accountnumberforaccruedasallery = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.defaultaccountnumberforaccruedpayment = dbcontext.GL_AccountSetup.ToList().Select(m => new { Code = m.Account + "-[" + m.AccountName + ']', ID = m.ID });
ViewBag.checktype = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-[" + m.Description + ']', ID = m.ID });
ViewBag.deathdaysubscriptioncode = dbcontext.Subscription_Syndicate.ToList().Select(m => new { Code = m.Subscription_Code + "-[" + m.Subscription_Description + ']', ID = m.ID });
ViewBag.Basicsallarycode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.totalexcludedallwencecode = dbcontext.salary_code.Where(m => m.SourceEntry == 1 || m.SourceEntry == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///contract and transaction
ViewBag.earnedsallarycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 1).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///earned money type
ViewBag.deductedsallerycode = dbcontext.salary_code.Where(m => m.CodeGroupType == 2).Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList(); ///deducted money type
ViewBag.Deathdaysallarycode = dbcontext.salary_code.Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + "-]", ID = m.ID }).ToList();
var record_edit = dbcontext.PayrollGeneralSetup.FirstOrDefault(m => m.ID == model.PayrollGeneralSetup.ID);
//var new_model = model.PayrollGeneralSetup;
var allow = form["check_A"].Split(',');
var PUNI = form["check_B"].Split(',');
if (allow.Length == 1)
{
record_edit.AllowToRounding = false;
}
else
{
record_edit.AllowToRounding = true;
}
if (PUNI[0] == "first")
{
record_edit.Rest_On_The_First_Punishment = true;
record_edit.Rest_On_The_Last_Punishment = false;
}
else
{
record_edit.Rest_On_The_First_Punishment = false;
record_edit.Rest_On_The_Last_Punishment = true;
}
record_edit.Rounding_Method = Convert.ToInt16(model.Rounding_method.GetHashCode());
record_edit.IntegrationType = Convert.ToInt16(model.ERP_INTERGRATION_TYPE.GetHashCode());
record_edit.GL_DistrbutionBehavior = Convert.ToInt16(model.GL_cost_center_distribution_behavior.GetHashCode());
record_edit.Modified_By = User.Identity.Name;
record_edit.Modified_Date = DateTime.Now.Date;
record_edit.AccountNumberForNetSalary = model.PayrollGeneralSetup.AccountNumberForNetSalary;
record_edit.DefaultAccountNumberForNetPayment = model.PayrollGeneralSetup.DefaultAccountNumberForNetPayment;
record_edit.DefaultPayrollPeriod = model.PayrollGeneralSetup.DefaultPayrollPeriod;
record_edit.GL_DistrbutionBehavior = model.PayrollGeneralSetup.GL_DistrbutionBehavior;
record_edit.IntegrationType = model.PayrollGeneralSetup.IntegrationType;
record_edit.Length_Of_Segment = model.PayrollGeneralSetup.Length_Of_Segment;
record_edit.Number_Of_Account_Segments = model.PayrollGeneralSetup.Number_Of_Account_Segments;
record_edit.SalaryCodeID_BasicSalary = model.PayrollGeneralSetup.SalaryCodeID_BasicSalary;
record_edit.SalaryCodeID_D = model.PayrollGeneralSetup.SalaryCodeID_D;
record_edit.SalaryCodeID_DeathDate = model.PayrollGeneralSetup.SalaryCodeID_DeathDate;
record_edit.SalaryCodeID_E = model.PayrollGeneralSetup.SalaryCodeID_E;
record_edit.SalaryCodeID_ExecludedAllwance = model.PayrollGeneralSetup.SalaryCodeID_ExecludedAllwance;
record_edit.Segment_Number_Of_Costcenter = model.PayrollGeneralSetup.Segment_Number_Of_Costcenter;
record_edit.Subscription_Code_DeathDate = model.PayrollGeneralSetup.Subscription_Code_DeathDate;
record_edit.Type_Code = model.PayrollGeneralSetup.Type_Code;
record_edit.Value = model.PayrollGeneralSetup.Value;
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("payroll general setup", HR.Models.user.Action.edit, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
