public ActionResult create() { try { ViewBag.Employee_Profile = dbcontext.Employee_Profile.Where(a => a.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.ManualPaymentTypes_Header = dbcontext.ManualPaymentTypes_Header.ToList().Select(m => new { Code = m.PaymentTypeCode + "-[" + m.PaymentTypeDesc + ']', ID = m.ID }); var Statis = DateTime.Now; var new_record = new ManualPaymentTransactionEntry { EffectiveDate = Statis, TransactionDate = Statis, FromDate = Statis, ToDate = Statis, PaidDate = Statis }; var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Payroll).Structure_Code; var model_ = dbcontext.ManualPaymentTransactionEntry.ToList(); if (model_.Count() == 0) { new_record.TransactionNumber = stru + "1"; } else { new_record.TransactionNumber = stru + (model_.LastOrDefault().ID + 1).ToString(); } var model = new HeaderManual { ManualPaymentTransactionEntry = new_record, Payment_Type_Source_Document = Payment_Type_Source_Document.Manual, check_status = check_status.Created }; return(View(model)); } catch (Exception) { return(RedirectToAction("index")); } }
public ActionResult Details(int id, string Trans, string Emp, string Man, string Source) { try { var Emps = int.Parse(Emp); ViewBag.Trans = Trans; ViewBag.Emp = dbcontext.Employee_Profile.Where(a => a.ID == Emps).FirstOrDefault().Full_Name; ViewBag.Empcode = dbcontext.Employee_Profile.Where(a => a.ID == Emps).FirstOrDefault().Code; var Mans = int.Parse(Man); ViewBag.Man = dbcontext.ManualPaymentTypes_Header.Where(a => a.ID == Mans).FirstOrDefault().PaymentTypeDesc; ViewBag.Mans = Man; ViewBag.Source = Source; ViewBag.Mans = Man; ViewBag.IDD = id; var old_model = dbcontext.ManualPaymentTransactionEntry.FirstOrDefault(m => m.ID == id); var header = new HeaderManual { ManualPaymentTransactionEntry = old_model, check_status = (check_status)old_model.TransactionStatus, Payment_Type_Source_Document = (Payment_Type_Source_Document)old_model.DocumentType }; return(View(header)); } catch (Exception) { return(RedirectToAction("index")); } }
public ActionResult edit(int id) { try { ViewBag.Employee_Profile = dbcontext.Employee_Profile.Where(a => a.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.ManualPaymentTypes_Header = dbcontext.ManualPaymentTypes_Header.ToList().Select(m => new { Code = m.PaymentTypeCode + "-[" + m.PaymentTypeDesc + ']', ID = m.ID }); ViewBag.id = id; var old_model = dbcontext.ManualPaymentTransactionEntry.FirstOrDefault(m => m.ID == id); var header = new HeaderManual { ManualPaymentTransactionEntry = old_model, check_status = (check_status)old_model.TransactionStatus, Payment_Type_Source_Document = (Payment_Type_Source_Document)old_model.DocumentType }; var old_details = dbcontext.ManualPaymentTransactionEntry_ExtendedFieldsDetail.Where(m => m.TransactionNumber == old_model.ID.ToString()).ToList(); var new_model = new VMs { ManualPaymentTransactionEntry_ExtendedFieldsDetail = old_details, Header = header }; return(View(new_model)); } catch (Exception) { return(RedirectToAction("index")); } }
public ActionResult Create(HeaderManual model, FormCollection form, string Command) { try { ViewBag.Employee_Profile = dbcontext.Employee_Profile.Where(a => a.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.ManualPaymentTypes_Header = dbcontext.ManualPaymentTypes_Header.ToList().Select(m => new { Code = m.PaymentTypeCode + "-[" + m.PaymentTypeDesc + ']', ID = m.ID }); var new_Record = model.ManualPaymentTransactionEntry; new_Record.ExtendedFields_Code = model.ManualPaymentTransactionEntry.ExtendedFields_Code; //var ExtendedFields_Code = int.Parse(model.ManualPaymentTransactionEntry.ExtendedFields_Code); //var EmpObj = dbcontext.ExtendedFields_Header.FirstOrDefault(a => a.ID == ExtendedFields_Code); new_Record.TransactionNumber = model.ManualPaymentTransactionEntry.TransactionNumber; new_Record.Employee_Code = model.ManualPaymentTransactionEntry.Employee_Code; //new_Record.ManualPaymentType = model.ManualPaymentTransactionEntry.ManualPaymentType == null ? model.ManualPaymentTransactionEntry.ManualPaymentType = EmpObj.ID.ToString() : model.ManualPaymentTransactionEntry.ManualPaymentType; new_Record.ManualPaymentType = model.ManualPaymentTransactionEntry.ManualPaymentType; new_Record.TransactionDate = model.ManualPaymentTransactionEntry.TransactionDate; new_Record.EffectiveDate = model.ManualPaymentTransactionEntry.EffectiveDate; new_Record.CurrentYear = model.ManualPaymentTransactionEntry.CurrentYear; new_Record.PreviousYear = model.ManualPaymentTransactionEntry.PreviousYear; new_Record.FromDate = model.ManualPaymentTransactionEntry.FromDate; new_Record.ToDate = model.ManualPaymentTransactionEntry.ToDate; new_Record.TransactionNumber = model.ManualPaymentTransactionEntry.TransactionNumber; new_Record.PaidDate = model.ManualPaymentTransactionEntry.PaidDate; new_Record.PaidReferenceNumber = model.ManualPaymentTransactionEntry.PaidReferenceNumber; new_Record.ReferenceNumber = model.ManualPaymentTransactionEntry.ReferenceNumber; new_Record.ReferenceDescription = model.ManualPaymentTransactionEntry.ReferenceDescription; new_Record.ReferenceNote = model.ManualPaymentTransactionEntry.ReferenceNote; new_Record.TransactionNote = model.ManualPaymentTransactionEntry.TransactionNote; new_Record.TransactionStatus = check_status.Created.GetHashCode(); new_Record.DocumentType = model.Payment_Type_Source_Document.GetHashCode(); DateTime statis2 = Convert.ToDateTime("1/1/1900"); new_Record.CreatedDate = DateTime.Now.Date; new_Record.CreatedBy = User.Identity.Name; new_Record.ReportAsReadyDate = statis2; new_Record.ApprovedDate = statis2; new_Record.RejectedDate = statis2; new_Record.CanceledDate = statis2; new_Record.CompletedDate = statis2; new_Record.Created_By = User.Identity.Name; new_Record.Created_Date = DateTime.Now.Date; new_Record.check_status = HR.Models.Infra.check_status.created; new_Record.name_state = nameof(check_status.Created); var username = User.Identity.GetUserName(); var Date = Convert.ToDateTime("1/1/1900"); var s = new status { statu = HR.Models.Infra.check_status.created, created_by = username, Type = Models.Infra.Type.ManualPaymentTransactionEntry, approved_bydate = Date, cancaled_bydate = Date, created_bydate = DateTime.Now.Date, Rejected_bydate = Date, return_to_reviewdate = Date }; var st = dbcontext.status.Add(s); dbcontext.SaveChanges(); new_Record.statID = s.ID; var Header = dbcontext.ManualPaymentTransactionEntry.Add(new_Record); dbcontext.SaveChanges(); /////////////////// var codeid = form["codeid"].Split(','); var SalaryDes = form["SalaryDes"].Split(','); var ValueType = form["ValueType"].Split(','); var DefaultValue = form["DefaultValue"].Split(','); for (var i = 0; i < codeid.Length; i++) { if (codeid[i] != "") { var value = double.Parse(DefaultValue[i]); var valuetype = ValueType[i]; var new_details = new ManualPaymentTransactionEntry_ExtendedFieldsDetail { TransactionNumber = Header.ID.ToString(), Created_By = User.Identity.Name, Created_Date = DateTime.Now.Date, Detail_Code = codeid[i], Detail_Desc = SalaryDes[i], ValueType = valuetype, Value = value }; dbcontext.ManualPaymentTransactionEntry_ExtendedFieldsDetail.Add(new_details); dbcontext.SaveChanges(); } } if (Command == "Submit") { return(RedirectToAction("Details", "ManualPaymentTransactionEntry", new { id = Header.ID, Trans = Header.TransactionNumber, Emp = Header.Employee_Code, Man = Header.ManualPaymentType, Source = Header.DocumentType }));//int.Parse(record.Employee_ProfileId) } //////////////// return(RedirectToAction("index")); } catch (Exception e) { return(View(model)); } }
public ActionResult PaymentSettlementMassTransaction(HeaderManual model, FormCollection form, string Command) { try { List <SelectListItem> items = new List <SelectListItem>(); items.Insert(0, (new SelectListItem { Text = "All employee", Value = "1", })); items.Insert(1, (new SelectListItem { Text = "unit", Value = "2", })); items.Insert(2, (new SelectListItem { Text = "nationality", Value = "3", })); items.Insert(3, (new SelectListItem { Text = "Work location", Value = "4", })); items.Insert(4, (new SelectListItem { Text = "Cost center", Value = "5", })); items.Insert(5, (new SelectListItem { Text = "Cadre level", Value = "6", })); ViewBag.Object = new SelectList(items, "Value", "Text"); ViewBag.Employee_Profile = dbcontext.Employee_Profile.Where(a => a.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.ManualPaymentTypes_Header = dbcontext.ManualPaymentTypes_Header.ToList().Select(m => new { Code = m.PaymentTypeCode + "-[" + m.PaymentTypeDesc + ']', ID = m.ID }); var list_emp = new List <Employee_Profile>(); var ID_emp = form["ID_emp"].Split(','); foreach (var item in ID_emp) { if (item != "") { var ID = int.Parse(item); var emp = dbcontext.Employee_Profile.FirstOrDefault(a => a.ID == ID); list_emp.Add(emp); } } foreach (var item2 in list_emp) { ManualPaymentTransactionEntry new_Record = new ManualPaymentTransactionEntry(); var model_ = dbcontext.ManualPaymentTransactionEntry.ToList(); var stru = dbcontext.StructureModels.FirstOrDefault(a => a.All_Models == ChModels.Payroll).Structure_Code; if (model_.Count() == 0) { new_Record.TransactionNumber = stru + "1"; } else { new_Record.TransactionNumber = stru + (model_.LastOrDefault().ID + 1).ToString(); } new_Record.Employee_Code = item2.ID.ToString(); new_Record.ManualPaymentType = model.ManualPaymentTransactionEntry.ManualPaymentType; new_Record.TransactionDate = model.ManualPaymentTransactionEntry.TransactionDate; new_Record.EffectiveDate = model.ManualPaymentTransactionEntry.EffectiveDate; new_Record.CurrentYear = model.ManualPaymentTransactionEntry.CurrentYear; new_Record.PreviousYear = model.ManualPaymentTransactionEntry.PreviousYear; new_Record.FromDate = model.ManualPaymentTransactionEntry.FromDate; new_Record.ToDate = model.ManualPaymentTransactionEntry.ToDate; new_Record.TransactionNote = model.ManualPaymentTransactionEntry.TransactionNote; new_Record.TransactionStatus = check_status.Created.GetHashCode(); new_Record.DocumentType = model.Payment_Type_Source_Document.GetHashCode(); new_Record.Created_By = User.Identity.Name; new_Record.Created_Date = DateTime.Now.Date; new_Record.check_status = HR.Models.Infra.check_status.created; new_Record.name_state = nameof(check_status.Created); var username = User.Identity.GetUserName(); var Date = Convert.ToDateTime("1/1/1900"); var s = new status { statu = HR.Models.Infra.check_status.created, created_by = username, Type = Models.Infra.Type.ManualPaymentTransactionEntry, approved_bydate = Date, cancaled_bydate = Date, created_bydate = DateTime.Now.Date, Rejected_bydate = Date, return_to_reviewdate = Date }; var st = dbcontext.status.Add(s); dbcontext.SaveChanges(); new_Record.statID = s.ID; var Header = dbcontext.ManualPaymentTransactionEntry.Add(new_Record); dbcontext.SaveChanges(); } //////////////// return(RedirectToAction("index")); } catch (Exception e) { return(View(model)); } }
public ActionResult PaymentSettlementMassTransaction() { try { List <SelectListItem> items = new List <SelectListItem>(); items.Insert(0, (new SelectListItem { Text = "All employee", Value = "1", })); items.Insert(1, (new SelectListItem { Text = "unit", Value = "2", })); items.Insert(2, (new SelectListItem { Text = "nationality", Value = "3", })); items.Insert(3, (new SelectListItem { Text = "Work location", Value = "4", })); items.Insert(4, (new SelectListItem { Text = "Cost center", Value = "5", })); items.Insert(5, (new SelectListItem { Text = "Cadre level", Value = "6", })); ViewBag.Object = new SelectList(items, "Value", "Text"); ViewBag.Employee_Profile = dbcontext.Employee_Profile.Where(a => a.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.ManualPaymentTypes_Header = dbcontext.ManualPaymentTypes_Header.ToList().Select(m => new { Code = m.PaymentTypeCode + "-[" + m.PaymentTypeDesc + ']', ID = m.ID }); var Statis = DateTime.Now; var new_record = new ManualPaymentTransactionEntry { EffectiveDate = Statis, TransactionDate = Statis, FromDate = Statis, ToDate = Statis, PaidDate = Statis }; var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Payroll).Structure_Code; var model_ = dbcontext.ManualPaymentTransactionEntry.ToList(); if (model_.Count() == 0) { new_record.TransactionNumber = stru + "1"; } else { new_record.TransactionNumber = stru + (model_.LastOrDefault().ID + 1).ToString(); } var model = new HeaderManual { ManualPaymentTransactionEntry = new_record, Payment_Type_Source_Document = new Payment_Type_Source_Document(), check_status = check_status.Created }; return(View(model)); } catch (Exception) { return(RedirectToAction("index")); } }