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