public ActionResult DriverPayroll(int id) { var obj = DB.Entities.Driver_Info.FirstOrDefault(m => m.ID == id); if (obj == null) { obj = new Driver_Info(); } // Show/hide button driver payroll & expanses var listEquipment = DB.Entities.Equipment.Where(m => m.Driver == id).ToList(); foreach (var equip in listEquipment) { if ((equip.OOS) || (int)(DateTime.Now - equip.LastInspected).TotalDays > equip.InspectionFrequency) { #region SELECT OPTION string dataOwners = "<option value=''>--Select Owners--</option>"; foreach (var item in NationalIT.DB.Entities.Owners) { if (obj != null && obj.Owner_Name == item.OwnerID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataOwners += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.OwnerID, item.Name); } else { dataOwners += string.Format("<option value='{0}'>{1}</option>", item.OwnerID, item.Name); } } ViewBag.dataOwners = dataOwners; string dataDispatchers = "<option value=''>--Select Dispatcher--</option>"; foreach (var item in NationalIT.DB.Entities.Dispatchers) { if (obj != null && obj.Dispatcher == item.ID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataDispatchers += string.Format("<option value='{0}' selected='selected'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } else { dataDispatchers += string.Format("<option value='{0}'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } } ViewBag.dataDispatchers = dataDispatchers; string dataTruck = "<option value=''>--Select Truck--</option>"; foreach (var item in NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRUCK"))) { if (obj != null && obj.Truck == item.Equipment_number) { dataTruck += string.Format("<option value='{0}' selected='selected'>{0}</option>", item.Equipment_number); } else { dataTruck += string.Format("<option value='{0}'>{0}</option>", item.Equipment_number); } } ViewBag.dataTruck = dataTruck; string dataTrailer = "<option value=''>--Select Trailer--</option>"; foreach (var item in NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRAILER"))) { if (obj != null && obj.Trailer == item.Equipment_number) { dataTrailer += string.Format("<option value='{0}' selected='selected'>{0}</option>", item.Equipment_number); } else { dataTrailer += string.Format("<option value='{0}'>{0}</option>", item.Equipment_number); } } ViewBag.dataTrailer = dataTrailer; // List payroll roll back var listPayroll = DB.Entities.TempReport.Where(m => m.DriverID == id).ToList(); ViewBag.ListPayroll = listPayroll; #endregion if (equip.OOS) { ModelState.AddModelError("", "Out of services"); } if ((int)(DateTime.Now - equip.LastInspected).TotalDays > equip.InspectionFrequency) { ModelState.AddModelError("", string.Format("Out of date equipment - {0} - {1}", equip.Equipment_Type, equip.Equipment_number)); } return(View("NewOrEdit", obj)); } } return(View(obj)); }
public ActionResult NewOrEdit(int?id = 0) { var obj = DB.Entities.Driver_Info.FirstOrDefault(m => m.ID == id); if (obj == null) { obj = new Driver_Info() { Expiration_Date = DateTime.Now } } ; #region SELECT OPTION string dataOwners = "<option value=''>--Select Owners--</option>"; foreach (var item in NationalIT.DB.Entities.Owners) { if (obj != null && obj.Owner_Name == item.OwnerID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataOwners += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.OwnerID, item.Name); } else { dataOwners += string.Format("<option value='{0}'>{1}</option>", item.OwnerID, item.Name); } } ViewBag.dataOwners = dataOwners; string dataDispatchers = "<option value=''>--Select Dispatcher--</option>"; foreach (var item in NationalIT.DB.Entities.Dispatchers) { if (obj != null && obj.Dispatcher == item.ID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataDispatchers += string.Format("<option value='{0}' selected='selected'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } else { dataDispatchers += string.Format("<option value='{0}'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } } ViewBag.dataDispatchers = dataDispatchers; string dataTruck = "<option value=''>--Select Truck--</option>"; var listTruck = NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRUCK")); foreach (var item in listTruck) { if (obj != null && obj.Truck == item.Equipment_number) { dataTruck += string.Format("<option value='{0}' selected='selected'>{0}</option>", item.Equipment_number); } else { dataTruck += string.Format("<option value='{0}'>{0}</option>", item.Equipment_number); } } ViewBag.dataTruck = dataTruck; string dataTrailer = "<option value=''>--Select Trailer--</option>"; var listTrailer = NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRAILER")); foreach (var item in listTrailer) { if (obj != null && obj.Trailer == item.Equipment_number) { dataTrailer += string.Format("<option value='{0}' selected='selected'>{0}</option>", item.Equipment_number); } else { dataTrailer += string.Format("<option value='{0}'>{0}</option>", item.Equipment_number); } } ViewBag.dataTrailer = dataTrailer; // List payroll roll back var listPayroll = DB.Entities.TempReport.Where(m => m.DriverID == id).ToList(); ViewBag.ListPayroll = listPayroll; #endregion return(View(obj)); }
public ActionResult NewOrEdit(Driver_Info model, FormCollection frm) { try { if (model.Owner || (!model.Owner) && model.Owner_Name.HasValue && model.Owner_Name.Value > 0) { if (model.Owner_Pay_Rate > 0) { var db = DB.Entities; model.Expiration_Date = CommonFunction.ChangeFormatDate(frm["Expiration_Date"]).Value; model.Date_Issued = CommonFunction.ChangeFormatDate(frm["Date_Issued"]); if (model.ID == 0) { // Edit db.Driver_Info.AddObject(model); } else { // Add new db.AttachTo("Driver_Info", model); db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified); } db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("Owner_Pay_Rate", "The field must be greate than 0"); } } else { ModelState.AddModelError("Owner_Name", "The field is required"); if (!(model.Owner_Pay_Rate > 0)) { ModelState.AddModelError("Owner_Pay_Rate", "The field must be greate than 0"); } } } catch { } #region SELECT OPTION string dataOwners = "<option value=''>--Select Owners--</option>"; foreach (var item in NationalIT.DB.Entities.Owners) { if (model != null && model.Owner_Name == item.OwnerID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataOwners += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.OwnerID, item.Name); } else { dataOwners += string.Format("<option value='{0}'>{1}</option>", item.OwnerID, item.Name); } } ViewBag.dataOwners = dataOwners; string dataDispatchers = "<option value=''>--Select Dispatcher--</option>"; foreach (var item in NationalIT.DB.Entities.Dispatchers) { if (model != null && model.Dispatcher == item.ID) { //dataDispatchers += "{ \"id\": " + item.ID + ", \"label\": \"" + item.Last_name + " " + item.First_name + "\" }"; dataDispatchers += string.Format("<option value='{0}' selected='selected'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } else { dataDispatchers += string.Format("<option value='{0}'>{1} {2}</option>", item.ID, item.Last_name, item.First_name); } } ViewBag.dataDispatchers = dataDispatchers; string dataTruck = "<option value=''>--Select Truck--</option>"; foreach (var item in NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRUCK"))) { if (model != null && model.Truck == item.Equipment_number) { dataTruck += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.Equipment_number, item.Equipment_number); } else { dataTruck += string.Format("<option value='{0}'>{1}</option>", item.Equipment_number, item.Equipment_number); } } ViewBag.dataTruck = dataTruck; string dataTrailer = "<option value=''>--Select Trailer--</option>"; foreach (var item in NationalIT.DB.Entities.Equipment.Where(m => m.Equipment_Type.Equals("TRAILER"))) { if (model != null && model.Trailer == item.Equipment_number) { dataTrailer += string.Format("<option value='{0}' selected='selected'>{1}</option>", item.Equipment_number, item.Equipment_number); } else { dataTrailer += string.Format("<option value='{0}'>{1}</option>", item.Equipment_number, item.Equipment_number); } } ViewBag.dataTrailer = dataTrailer; #endregion // List payroll roll back var listPayroll = DB.Entities.TempReport.Where(m => m.DriverID == model.ID).ToList(); ViewBag.ListPayroll = listPayroll; return(View(model)); }