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