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