public ActionResult Create() { try { ViewBag.emp = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.daystate = dbcontext.Shiftdaystatus.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); var model = new Employee_Shift_schedule(); return(View(model)); } catch (Exception) { return(RedirectToAction("index")); } }
public ActionResult Create(FormCollection form, Employee_Shift_schedule model) { try { ViewBag.emp = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.daystate = dbcontext.Shiftdaystatus.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); var actual_shift = dbcontext.Employee_Shift_schedule.Add(model); dbcontext.SaveChanges(); if (model.Use_As_Default == true) { var all_schedule_for_this_employee = dbcontext.Employee_Shift_schedule.Where(m => m.Use_As_Default == true && m.ID != actual_shift.ID); foreach (var item in all_schedule_for_this_employee) { item.Use_As_Default = false; dbcontext.SaveChanges(); } } ////////////////////////////////////////// var from_D = form["fromdate"].Split(','); var to_D = form["todate"].Split(','); var from_T = form["fromtime"].Split(','); var to_T = form["totime"].Split(','); var shift = form["shift_ID"].Split(','); var state = form["status_ID"].Split(','); var Temco = form["Temco"].Split(','); var TemDe = form["TemDe"].Split(','); var TemDeAl = form["TemDeAl"].Split(','); var temp = new Template(); if (TemDe[0] != "") { temp.TemplateCode = Temco[0]; temp.TemplateDescription = TemDe[0]; temp.Employee_Shift_scheduleID = actual_shift.ID; if (TemDeAl[0] != "") { temp.TemplateAllternativeDescription = TemDeAl[0]; } else { temp.TemplateAllternativeDescription = null; } temp.To_date = actual_shift.To_date; temp.From_date = actual_shift.From_date; dbcontext.Template.Add(temp); dbcontext.SaveChanges(); } for (var i = 0; i < shift.Count(); i++) { var Si_id = int.Parse(shift[i]); var St_id = int.Parse(state[i]); var f_D = Convert.ToDateTime(from_D[i]); var t_D = Convert.ToDateTime(to_D[i]); var f_t = Convert.ToDateTime(from_T[i]).TimeOfDay; var t_t = Convert.ToDateTime(to_T[i]).TimeOfDay; var details = new Schedule_Details {/*Template = actual_shift.TemplateCode,*/ Employee_Shift_scheduleID = actual_shift.ID, Shift_setupID = Si_id, ShiftdaystatusID = St_id, From_date = f_D, To_date = t_D, From = f_t, To = t_t }; dbcontext.Schedule_Details.Add(details); dbcontext.SaveChanges(); if (TemDe[0] != "") { var detailss = new Shiftscheduletemplate { TemplateAllternativeDescription_Shifts = TemDeAl[0], TemplateDescription_Shifts = TemDe[0], TemplateCode_Shifts = Temco[0], Employee_Shift_scheduleID = actual_shift.ID, Shift_setupID = Si_id, ShiftdaystatusID = St_id, From_date = f_D, To_date = t_D, From = f_t, To = t_t }; dbcontext.Shiftscheduletemplate.Add(detailss); dbcontext.SaveChanges(); } } ///////////////////////////////////////// return(RedirectToAction("index")); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Template model, FormCollection form, DateTime?fromDDD, string toD) { 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"); var ID_emp = form["ID_emp"].Split(','); var codeids = form["codeids"].Split(','); var Description = form["TempDe"].Split(','); var DescriptionAl = form["TempDeAl"].Split(','); //var fromD = form["fromDDD"].Split(','); //var toDs = form["toD"].Split(','); var code = codeids[0]; var Shiftscheduletemplate = dbcontext.Shiftscheduletemplate.Where(a => a.TemplateCode_Shifts == code).ToList(); for (int e = 0; e < ID_emp.Count(); e++) { if (ID_emp[e] != "") { var id = int.Parse(ID_emp[e]); Employee_Shift_schedule new_Records = new Employee_Shift_schedule(); dbcontext.Configuration.ProxyCreationEnabled = false; var num_of_sch = dbcontext.Employee_Shift_schedule.Where(m => m.Employee_ProfileID == id).ToList(); var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == id); var codes = ""; if (num_of_sch.Count == 0) { codes = emp.Code + "_SCH_1"; } else { codes = emp.Code + "_SCH_" + (num_of_sch.Count() + 1); } new_Records.Code = codes; var emps = int.Parse(ID_emp[e]); new_Records.Employee_ProfileID = emps; var Des = Description[0]; new_Records.Name = Des; var DesAl = DescriptionAl[0]; new_Records.Description = DesAl; new_Records.From_date = model.From_date; new_Records.To_date = model.To_date; var Headers = dbcontext.Employee_Shift_schedule.Add(new_Records); dbcontext.SaveChanges(); for (var i = 0; i < Shiftscheduletemplate.Count(); i++) { Schedule_Details new_Record = new Schedule_Details(); new_Record.Employee_Shift_scheduleID = Headers.ID; new_Record.From = Shiftscheduletemplate[i].From; new_Record.To = Shiftscheduletemplate[i].To; new_Record.From_date = Shiftscheduletemplate[i].From_date; new_Record.To_date = Shiftscheduletemplate[i].To_date; new_Record.ShiftdaystatusID = Shiftscheduletemplate[i].ShiftdaystatusID; new_Record.Shift_setupID = Shiftscheduletemplate[i].Shift_setupID; var Header = dbcontext.Schedule_Details.Add(new_Record); dbcontext.SaveChanges(); } } } //////////////// return(RedirectToAction("index", "EmployeeShift")); } catch (Exception e) { return(View(model)); } }
public ActionResult ViewExecl(Employee_Shift_schedule model, FormCollection form) { try { var AllData = ViewBag.Data; var EmpCode = form["EmployeeCode"].Split(','); var EmpName = form["EmployeeName"].Split(','); var Date = form["Date"].Split(','); var In = form["In"].Split(','); var Out = form["Out"].Split(','); for (var co = 0; co < EmpCode.Length; co++) { var Code = EmpCode[co]; var ChCode = dbcontext.Employee_Profile.Where(a => a.Active == true).FirstOrDefault(a => a.Code == Code); if (ChCode == null) { TempData["Message"] = "Not found this data " + Code; return(RedirectToAction("Index", "Employee_Payroll_Transactions")); } } //for (var na = 0; na < EmpName.Length; na++) //{ // var Name = EmpName[na]; // var ChName = dbcontext.Employee_Profile.Where(a => a.Active == true).FirstOrDefault(a => a.Name == Name); // if (ChName == null) // { // TempData["Message"] = "Not found this data " + Name; // return RedirectToAction("Index", "Employee_Payroll_Transactions"); // } //} for (var c = 0; c < EmpCode.Length; c++) { if (EmpCode[c] != "") { var CoEmp = EmpCode[c]; var NaEmp = EmpName[c]; var ChName = dbcontext.Employee_Profile.Where(a => a.Active == true).FirstOrDefault(a => a.Code == CoEmp && a.Name == NaEmp); if (ChName == null) { TempData["Message"] = "Not found this data " + CoEmp + " " + NaEmp; return(RedirectToAction("Index", "Employee_Payroll_Transactions")); } Employee_Shift_schedule newdata = new Employee_Shift_schedule(); var Employee_Shift_schedule = dbcontext.Employee_Shift_schedule.ToList(); var Stru = dbcontext.StructureModels.FirstOrDefault(a => a.All_Models == ChModels.Payroll).Structure_Code; if (Employee_Shift_schedule.Count() == 0) { newdata.Code = Stru + "1"; } else { newdata.Code = Stru + (Employee_Shift_schedule.LastOrDefault().ID + 1).ToString(); } //newdata.Employee_Code = CoEmp; //newdata.SalaryCodeID = SalaCode; //newdata.TransactionValue = 0; //newdata.TransactionDate = DateTime.Parse(Transaction[c]); //newdata.TransactionYear = DateTime.Parse(Transaction[c]).Year; //newdata.TransactionMonth = DateTime.Parse(Transaction[c]).Month; //newdata.EffectiveDate = DateTime.Parse(Effective[c]); //newdata.EffectiveYear = DateTime.Parse(Effective[c]).Year; //newdata.EffectiveMonth = DateTime.Parse(Effective[c]).Month; //newdata.Created_By = User.Identity.Name; //newdata.Created_Date = DateTime.Now.Date; //newdata.CreatedBy = User.Identity.Name; //newdata.CreatedDate = DateTime.Now.Date; //DateTime statis2 = Convert.ToDateTime("1/1/1900"); //newdata.ReportAsReadyDate = statis2; //newdata.ApprovedDate = statis2; //newdata.RejectedDate = statis2; //newdata.CanceledDate = statis2; //newdata.CompletedDate = statis2; //newdata.Modified_Date = statis2; //newdata.check_status = HR.Models.Infra.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.Employee_Payroll_Transactions, 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(); //newdata.statID = s.ID; //dbcontext.Employee_Payroll_Transactions.Add(newdata); //dbcontext.SaveChanges(); } } return(RedirectToAction("Index", "Employee_Payroll_Transactions")); } catch (Exception e) { TempData["Message"] = "Not found this data"; return(RedirectToAction("Index", "Employee_Payroll_Transactions")); } }