public ActionResult CreateUser([Bind(Include = "Username,Password,Department,Permission,FirstName")] User createUser)
{
using (TrailerEntities db = new TrailerEntities())
{
if (ModelState.IsValid)
{
User newUser = new User()
{
Username = createUser.Username,
Password = createUser.Password,
Department = createUser.Department,
Permission = createUser.Permission,
FirstName = createUser.FirstName,
Email = createUser.Email
};
if (db.Users.Any(u => u.Username == newUser.Username))
{
ModelState.AddModelError("Username", "Username is already in use");
return(View());
}
db.Users.Add(newUser);
db.SaveChanges();
return(RedirectToAction(actionName: "UserList", controllerName: "Users"));
}
return(View());
}
}
public ActionResult RemoveUser(string username)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_MANAGER)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
var user = db.Users.Where(u => u.Username == username).FirstOrDefault();
if (user.Username == Session["username"].ToString())
{
SignOut();
}
db.Users.Remove(user);
db.SaveChanges();
return(RedirectToAction(actionName: "UserList", controllerName: "Users"));
}
}
}
}
public ActionResult RemoveFromMasterList(string trailerNumber)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_MANAGER)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
var trailer = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber);
db.TrailerLists.Remove(trailer);
var activeTrailer = db.ActiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber);
//removes trailer from master and active if trailer exists in active
if (activeTrailer != null)
{
db.ActiveTrailerLists.Remove(activeTrailer);
}
db.SaveChanges();
return(RedirectToAction(actionName: "InactiveTrailerList", controllerName: "Trailer"));
}
}
}
}
public ActionResult CreateLocationRow([Bind(Include = "LocationNumber,RowNumber")] ActiveLocationRow newRow)
{
using (TrailerEntities db = new TrailerEntities())
{
if (db.ActiveLocationRows.Any(a => a.LocationNumber == newRow.LocationNumber && a.RowNumber == newRow.RowNumber))
{
ModelState.AddModelError("RowNumber", "Row number " + newRow.RowNumber + " already exists in this location");
ViewBag.MaxRowNumber = newRow.RowNumber;
ViewBag.LocationNumber = newRow.LocationNumber;
return(View());
}
else
{
var locationNumber = newRow.LocationNumber;
var location = db.ActiveInventoryLocations.FirstOrDefault(l => l.LocationNumber == newRow.LocationNumber);
location.NumberOfRows++;
ActiveLocationRow row = new ActiveLocationRow()
{
LocationNumber = newRow.LocationNumber,
RowNumber = newRow.RowNumber,
NumberOfPartNumbers = 0,
NumberOfStacks = 0,
PalletCount = 0,
};
db.ActiveLocationRows.Add(row);
db.SaveChanges();
return(RedirectToAction(actionName: "ActiveLocationRows", controllerName: "Inventory", routeValues: new { locationID = locationNumber }));
}
}
}
public ActionResult EditProductionEmployee(int employeeID, string name, int badgeNumber, string status)
{
using (TrailerEntities db = new TrailerEntities())
{
var employee = db.ProductionEmployees.FirstOrDefault(e => e.ProductionEmployeeGUID == employeeID);
var workstation = db.Workstations.FirstOrDefault(w => w.EmployeeBadgeNumberAssigned == employee.EmployeeBadgeNumber);
employee.EmployeeName = name;
employee.EmployeeBadgeNumber = badgeNumber;
employee.Status = status;
employee.NameAndBadgeNumber = (employee.EmployeeName + " - " + employee.EmployeeBadgeNumber);
if (workstation != null)
{
if (employee.Status == "INACTIVE")
{
workstation.EmployeeBadgeNumberAssigned = null;
}
else
{
workstation.EmployeeBadgeNumberAssigned = badgeNumber;
}
}
db.SaveChanges();
return(RedirectToAction(actionName: "ProductionEmployees", controllerName: "Production"));
}
}
public ActionResult RemoveConcern(int concernID)
{
using (TrailerEntities db = new TrailerEntities())
{
var concern = db.DriverConcerns.FirstOrDefault(c => c.DriverConcernGUID == concernID);
var images = db.DriverConcernImages.Where(c => c.DriverConcernGUID == concernID).ToList();
if (images.Count > 0)
{
foreach (DriverConcernImage image in images)
{
var path = Server.MapPath("~/DriverImages/" + image.ImagePath);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
db.DriverConcernImages.Remove(image);
}
}
db.DriverConcerns.Remove(concern);
db.SaveChanges();
return(RedirectToAction(actionName: "Index", controllerName: "Home"));
}
}
public ActionResult EditInactiveTrailer([Bind(Include = "TrailerNumber,DOTDate,TrailerStatus,Leased,InsuranceCard,Insured,Title,PlateNumber,VinNumber,Manufacturer,ManufactureYear,TrailerLength,Issues,Tags,DateModified")] InactiveTrailerList UpdatedTrailer)
{
using (TrailerEntities db = new TrailerEntities())
{
InactiveTrailerList trailer = db.InactiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber);
trailer.TrailerNumber = UpdatedTrailer.TrailerNumber;
trailer.DOTDate = UpdatedTrailer.DOTDate;
trailer.TrailerStatus = UpdatedTrailer.TrailerStatus;
trailer.Leased = UpdatedTrailer.Leased;
trailer.InsuranceCard = UpdatedTrailer.InsuranceCard;
trailer.Insured = UpdatedTrailer.Insured;
trailer.Title = UpdatedTrailer.Title;
trailer.PlateNumber = UpdatedTrailer.PlateNumber;
trailer.VinNumber = UpdatedTrailer.VinNumber;
trailer.Manufacturer = UpdatedTrailer.Manufacturer;
trailer.ManufactureYear = UpdatedTrailer.ManufactureYear;
trailer.TrailerLocation = UpdatedTrailer.TrailerLocation;
trailer.TrailerLength = UpdatedTrailer.TrailerLength;
trailer.Issues = UpdatedTrailer.Issues;
trailer.DateModified = UpdatedTrailer.DateModified;
db.SaveChanges();
return(RedirectToAction(actionName: "InactiveTrailerList", controllerName: "Trailer"));
}
}
public ActionResult ViewRowStacks(int rowID)
{
using (TrailerEntities db = new TrailerEntities())
{
dynamic model = new ExpandoObject();
var location = db.ActiveLocationRows.FirstOrDefault(l => l.InventoryRowGUID == rowID);
ViewBag.LocationNumber = location.LocationNumber;
ViewBag.RowNumber = location.RowNumber;
var stacks = db.InventoryRowStacks.Where(p => p.InventoryRowGUID == rowID).ToList();
var partNumbers = db.InventoryRowStacks.Where(p => p.InventoryRowGUID == rowID).Select(p => p.PartNumber).Distinct().ToList();
this.ViewData["partNumbers"] = new SelectList(db.PalletTypes.Where(c => c.Type != "SCRAP" && c.Type != "DEDUCTION").OrderBy(c => c.PartNumber), "PartNumber", "PartNumberDescription").ToList();
model.Stacks = stacks;
model.PartNumbers = partNumbers;
var parts = "";
foreach (var stack in partNumbers)
{
parts += stack + ",";
}
parts = parts.Substring(0, parts.Length - 1);
ViewBag.Parts = parts;
return(View(model));
}
}
public ActionResult ManagerDashboard()
{
using (TrailerEntities db = new TrailerEntities())
{
if (Session["username"] != null)
{
dynamic model = new ExpandoObject();
//var concerns = from x in db.SafetyConcerns select x;
//concerns = concerns.Where(c => c.Status == "OPEN" && c.Area == area).OrderBy(c => c.Area).ThenBy(c => c.SubArea);
var department = Session["departmentName"].ToString();
if (department == "Admin")
{
var concerns = db.SafetyConcerns.Where(c => c.Status == "OPEN" && c.SupposedlyFixed != true).OrderBy(c => c.Area).ThenByDescending(c => c.ViolationCount).ThenBy(c => c.SubArea).ToList();
return(View(concerns));
}
else
{
var concerns = db.SafetyConcerns.Where(c => c.Status == "OPEN" && c.Area == department && c.SupposedlyFixed != true).OrderBy(c => c.ViolationCount).ToList();
return(View(concerns));
}
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
}
public ActionResult EditSafetyCode([Bind(Include = "SafetyCodeGUID,Type,SubType,OshaCode,Description")] SafetyCode editSafetyCode)
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == 4500 || Convert.ToInt32(Session["department"]) == 10000))
{
using (TrailerEntities db = new TrailerEntities())
{
var code = db.SafetyCodes.FirstOrDefault(c => c.SafetyCodeGUID == editSafetyCode.SafetyCodeGUID);
code.Type = editSafetyCode.Type;
code.SubType = editSafetyCode.SubType;
code.OshaCode = editSafetyCode.OshaCode;
code.Description = editSafetyCode.Description;
code.TypeSubType = editSafetyCode.Type + " - " + editSafetyCode.SubType;
db.SaveChanges();
return(RedirectToAction(actionName: "SafetyCodes", controllerName: "Safety"));
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult EditSafetyCode(int safetyCodeID)
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_SUPER_ADMIN))
{
using (TrailerEntities db = new TrailerEntities())
{
var code = db.SafetyCodes.FirstOrDefault(c => c.SafetyCodeGUID == safetyCodeID);
if (code.Status == "INACTIVE")
{
ViewBag.Closed = true;
}
var codes = db.SafetyCodes.DistinctBy(c => c.Type).OrderBy(c => c.Type).ToList();
this.ViewData["codeTypes"] = new SelectList(codes, "Type", "Type").ToList();
return(View(code));
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult ReOpenSafetyConcern(int safetyConcernID)
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_SUPER_ADMIN))
{
using (TrailerEntities db = new TrailerEntities())
{
var concern = db.SafetyConcerns.FirstOrDefault(c => c.SafetyConcernGUID == safetyConcernID);
concern.Status = "OPEN";
concern.SupposedlyFixed = false;
concern.ViolationCount++;
concern.DateClosed = null;
concern.DateOpened = DateTime.Now.ToString("yyyy-MM-dd");
db.SaveChanges();
return(RedirectToAction(actionName: "SafetyAudit", controllerName: "Safety"));
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult AddSafetyConcern(string area)
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_SUPER_ADMIN))
{
using (TrailerEntities db = new TrailerEntities())
{
var codes = db.SafetyCodes.OrderBy(c => c.TypeSubType).ToList();
ViewBag.Area = area;
this.ViewData["typeSubType"] = new SelectList(codes, "TypeSubType", "TypeSubType");
this.ViewData["typeSubType2"] = new SelectList(codes, "TypeSubType", "TypeSubType");
var areas = db.Departments.Where(a => a.DepartmentName != "ADMIN").OrderBy(a => a.DepartmentName).ToList();
this.ViewData["departments"] = new SelectList(areas, "DepartmentName", "DepartmentName").ToList();
return(View());
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult ClosedSafetyConcerns()
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) == constant.DEPARTMENT_SUPER_ADMIN))
{
using (TrailerEntities db = new TrailerEntities())
{
dynamic model = new ExpandoObject();
var concerns = db.SafetyConcerns.Where(c => c.Status == "CLOSED").OrderByDescending(c => c.DateClosed).ToList();
model.Concerns = concerns;
var violations = db.CodeViolations.ToList();
model.Violations = violations;
return(View(model));
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult CreateSafetyCode([Bind(Include = "Type,SubType,OshaCode,Description")] SafetyCode createSafetyCode)
{
if (Session["username"] != null && (Convert.ToInt32(Session["department"]) == 4500 || Convert.ToInt32(Session["department"]) == 10000))
{
using (TrailerEntities db = new TrailerEntities())
{
SafetyCode newCode = new SafetyCode()
{
Type = createSafetyCode.Type,
SubType = createSafetyCode.SubType,
OshaCode = createSafetyCode.OshaCode,
Description = createSafetyCode.Description,
TypeSubType = createSafetyCode.Type + " - " + createSafetyCode.SubType,
Status = "ACTIVE",
};
db.SafetyCodes.Add(newCode);
db.SaveChanges();
return(RedirectToAction(actionName: "SafetyCodes", controllerName: "Safety"));
}
}
else if (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_HR_SAFETY || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
}
public ActionResult DriverDeliverNotes(int driverConcernID)
{
using (TrailerEntities db = new TrailerEntities())
{
SmtpClient client = new SmtpClient("smtp.ufpi.com", 25);
client.Timeout = 100000;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
var concern = db.DriverConcerns.FirstOrDefault(c => c.DriverConcernGUID == driverConcernID);
concern.Status = "CLOSED";
db.SaveChanges();
string customerServiceEmail = "*****@*****.**";
string body = "The following customer information was recorded during a delivery, taken by " + concern.DateTaken + ". <br><br> <a href=\"trailermanagement.palletusa.local/Trailer/DriverConcern?driverConcernID=" + driverConcernID + "\"> Click to view </a><br><br> This is an autogenerated message.";
MailMessage message = new MailMessage("*****@*****.**", customerServiceEmail, "Driver Delivery Notes", body);
//MailMessage message = new MailMessage("*****@*****.**", "*****@*****.**", "Driver Delivery Notes", body);
message.IsBodyHtml = true;
message.BodyEncoding = UTF8Encoding.UTF8;
//uncomment to send emails to customer service
client.Send(message);
return(RedirectToAction(actionName: "Index", controllerName: "Home"));
}
}
public ActionResult EditUser(int id)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
this.ViewData["departments"] = new SelectList(db.Departments, "DepartmentNumber", "DepartmentName").ToList();
var user = db.Users.Find(id);
if (user.UserGUID != Convert.ToInt32(Session["userID"]) && (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_MANAGER))
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
user = db.Users.Find(id);
return(View(user));
}
}
}
}
public ActionResult DriverConcernList()
{
using (TrailerEntities db = new TrailerEntities())
{
var concerns = db.DriverConcernsLists.OrderBy(c => c.Concern).ToList();
return(View(concerns));
}
}
public ActionResult ActiveInventoryLocations()
{
using (TrailerEntities db = new TrailerEntities())
{
var locations = db.ActiveInventoryLocations.ToList();
return(View(locations));
}
}
public ActionResult WorkOrders()
{
using (TrailerEntities db = new TrailerEntities())
{
var workOrders = db.ProductionWorkOrders.ToList();
return(View(workOrders));
}
}
public ActionResult ProductionEmployees()
{
using (TrailerEntities db = new TrailerEntities())
{
var employees = db.ProductionEmployees.OrderBy(e => e.Status).ThenBy(e => e.EmployeeName).ToList();
return(View(employees));
}
}
public ActionResult AddToRow(FormCollection fc)
{
using (TrailerEntities db = new TrailerEntities())
{
string[] input = fc.AllKeys;
var locationID = fc["locationNumber"];
var rowNumber = Convert.ToInt32(fc["rowNumber"]);
var partNumbers = fc["partNumbers"].Split(',');
List <string> uniquePartNumbers = new List <string>();
foreach (var part in partNumbers)
{
if (!uniquePartNumbers.Contains(part))
{
uniquePartNumbers.Add(part);
}
}
var location = db.ActiveLocationRows.FirstOrDefault(r => r.LocationNumber == locationID && r.RowNumber == rowNumber);
location.NumberOfPartNumbers = uniquePartNumbers.Count;
location.NumberOfStacks = 0;
location.PalletCount = 0;
var stacks = db.InventoryRowStacks.Where(s => s.InventoryRowGUID == location.InventoryRowGUID);
foreach (InventoryRowStack stack in stacks)
{
db.InventoryRowStacks.Remove(stack);
}
for (var x = 3; x < fc.Count; x++)
{
var key = fc.GetKey(x);
var dashIndex = Convert.ToInt32(key.IndexOf('-'));
var partIndex = Convert.ToInt32(key.Substring(0, dashIndex)) - 1;
var stackNumber = Convert.ToInt32(key.Substring((dashIndex + 1), (key.Length - 1 - dashIndex)));
var quantity = Convert.ToInt32(fc[key]);
location.PalletCount += quantity;
InventoryRowStack newStack = new InventoryRowStack()
{
InventoryRowGUID = location.InventoryRowGUID,
PartNumber = partNumbers[partIndex],
StackQuantity = quantity,
StackNumber = stackNumber,
};
db.InventoryRowStacks.Add(newStack);
}
var lastStack = fc.GetKey(fc.Count - 1);
var lastDashIndex = lastStack.IndexOf('-');
var totalStacks = Convert.ToInt32(fc.GetKey(fc.Count - 1).Substring(lastDashIndex + 1, (lastStack.Length - 1 - lastDashIndex)));
location.NumberOfStacks = totalStacks;
db.SaveChanges();
return(RedirectToAction(actionName: "ActiveLocationRows", controllerName: "Inventory", routeValues: new { locationID }));
}
}
public ActionResult EditUser([Bind(Include = "Username,Password,Department,Permission,FirstName")] User updatedUser, int id)
{
using (TrailerEntities db = new TrailerEntities())
{
User user = db.Users.Find(id);
if (db.Users.Any(t => t.Username == updatedUser.Username) && (user.Username != updatedUser.Username))
{
ModelState.AddModelError("Username", "Username already exists");
if (updatedUser.Password == null)
{
ModelState.AddModelError("Password", "Enter a new password or cancel");
}
return(View());
}
else if (updatedUser.Username == null)
{
ModelState.AddModelError("Username", "Username required");
return(View());
}
else if (updatedUser.Password == null)
{
ModelState.AddModelError("Password", "Password is required to save");
return(View());
}
else if (updatedUser.FirstName == null)
{
ModelState.AddModelError("FirstName", "Name field is required");
return(View());
}
else
{
if (Session["name"].Equals(updatedUser.FirstName))
{
Session["name"] = updatedUser.FirstName;
Session["permission"] = updatedUser.Permission;
Session["department"] = updatedUser.Department;
}
user.Username = updatedUser.Username;
user.Password = updatedUser.Password;
user.Department = updatedUser.Department;
user.FirstName = updatedUser.FirstName;
user.Permission = updatedUser.Permission;
db.SaveChanges();
}
if ((Convert.ToInt32(Session["permission"]) > 30))
{
return(RedirectToAction(actionName: "UserList", controllerName: "Users"));
}
else
{
return(RedirectToAction(actionName: "Index", controllerName: "Home"));
}
}
}
public ActionResult ProductionWorkHours(string date)
{
using (TrailerEntities db = new TrailerEntities())
{
if (db.ProductionStacks.Any(d => d.Date == date))
{
dynamic model = new ExpandoObject();
var stacks = db.ProductionStacks.Where(s => s.Date == date).OrderBy(s => s.WorkstationNumber).ToList();
var workstations = stacks.Select(w => w.WorkstationNumber).Distinct().ToList();
model.Workstations = workstations;
var users = stacks.Select(u => u.EmployeeName).Distinct().ToList();
model.Users = users;
var hours = db.ProductionHours.Where(h => h.Date == date).OrderBy(h => h.WorkstationNumber).ToList();
if (hours.Count > 0)
{
decimal[] hoursWorked = new decimal[users.Count];
for (var x = 0; x < users.Count; x++)
{
try
{
hoursWorked[x] = Convert.ToDecimal(hours[x].HoursWorked);
}
catch
{
hoursWorked[x] = 8;
}
}
model.Hours = hoursWorked;
}
else
{
List <Decimal> hoursWorked = new List <decimal>();
foreach (int workstation in workstations)
{
hoursWorked.Add(0);
}
model.Hours = hoursWorked;
}
var badgeNumbers = stacks.Select(b => b.EmployeeBadgeNumber).Distinct().ToList();
model.BadgeNumber = badgeNumbers;
model.Date = date;
return(View(model));
}
else
{
return(RedirectToAction(actionName: "ProductionDates", controllerName: "Reporting"));
}
}
}
public ActionResult UserList(string SortOrder)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_MANAGER)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
ViewBag.Username = String.IsNullOrEmpty(SortOrder) ? "Username_desc" : "";
ViewBag.Permission = SortOrder == "Permission" ? "Permission_desc" : "Permission";
var user = from x in db.Users select x;
var department = Session["department"].ToString();
if (!department.Equals("10000"))
{
user = user.Where(t => t.Permission != constant.PERMISSION_MANAGER.ToString() && t.Department.Equals(department));
}
switch (SortOrder)
{
case "Username_desc":
user = user.OrderByDescending(t => t.Username);
break;
case "Permission":
user = user.OrderByDescending(t => t.Permission);
break;
case "Permission_desc":
user = user.OrderBy(t => t.Permission);
break;
default:
user = user.OrderBy(t => t.Username);
break;
}
dynamic model = new ExpandoObject();
var departments = db.Departments.ToList();
model.Departments = departments;
model.Users = user.ToList();
return(View(model));
}
}
}
}
public ActionResult EditActiveTrailer([Bind(Include = "TrailerGUID,TrailerNumber,TrailerStatus,LoadStatus,Customer,OrderDate,OrderNumber,LocationStatus,TrailerLocation,Notes,Tags,DateModified,LastModifiedBy")] ActiveTrailerList UpdatedTrailer)
{
using (TrailerEntities db = new TrailerEntities())
{
ActiveTrailerList trailer = db.ActiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber);
if (!constant.checkIfEqual(trailer, UpdatedTrailer))
{
trailer.DateModified = DateTime.Now.ToString("yyyy-MM-dd");
}
TrailerList trailerEdit = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber);
if (trailer.TrailerStatus != constant.TRAILER_STATUS_NEED_EMPTY && UpdatedTrailer.TrailerStatus == constant.TRAILER_STATUS_NEED_EMPTY)
{
SortList newSort = new SortList()
{
TrailerNumber = UpdatedTrailer.TrailerNumber,
Customer = UpdatedTrailer.Customer,
OrderNumber = UpdatedTrailer.OrderNumber,
SortType = UpdatedTrailer.Notes,
LoadStatus = UpdatedTrailer.LoadStatus,
DateArrived = DateTime.Now.ToString("yyyy-MM-dd"),
Status = "NEW",
};
db.SortLists.Add(newSort);
}
if (trailerEdit != null)
{
trailerEdit.TrailerLocation = UpdatedTrailer.TrailerLocation;
}
trailer.TrailerStatus = UpdatedTrailer.TrailerStatus;
trailer.LoadStatus = UpdatedTrailer.LoadStatus;
trailer.Customer = UpdatedTrailer.Customer;
trailer.OrderDate = UpdatedTrailer.OrderDate;
trailer.OrderNumber = UpdatedTrailer.OrderNumber;
trailer.LocationStatus = UpdatedTrailer.LocationStatus;
if (UpdatedTrailer.TrailerStatus == constant.TRAILER_STATUS_DELIVERED)
{
trailer.TrailerLocation = UpdatedTrailer.Customer;
}
else
{
trailer.TrailerLocation = UpdatedTrailer.TrailerLocation;
}
trailer.Notes = UpdatedTrailer.Notes;
trailer.Tags = UpdatedTrailer.Tags;
trailer.LastModifiedBy = Session["name"].ToString();
db.SaveChanges();
return(RedirectToAction(actionName: "ActiveTrailerList", controllerName: "Trailer"));
}
}
public ActionResult EdidWorkOrderNumber(int workOrderID, int workOrderNumber)
{
using (TrailerEntities db = new TrailerEntities())
{
var workOrder = db.ProductionWorkOrders.FirstOrDefault(w => w.ProductionWorkOrderGUID == workOrderID);
workOrder.WorkOrderNumber = workOrderNumber;
db.SaveChanges();
return(RedirectToAction(actionName: "WorkOrders", controllerName: "Production"));
}
}
public ActionResult WorkstationInput()
{
using (TrailerEntities db = new TrailerEntities())
{
this.ViewData["workstation1"] = new SelectList(db.Workstations.Where(w => w.EmployeeBadgeNumberAssigned != null).OrderBy(w => w.WorkstationNumber), "WorkstationNumber", "WorkstationNumberName").ToList();
this.ViewData["workstation2"] = new SelectList(db.Workstations.Where(w => w.EmployeeBadgeNumberAssigned != null).OrderBy(w => w.WorkstationNumber), "WorkstationNumber", "WorkstationNumberName").ToList();
return(View());
}
}
public ActionResult DeleteConcernList(int concernID)
{
using (TrailerEntities db = new TrailerEntities())
{
var concern = db.DriverConcernsLists.FirstOrDefault(c => c.DriverConcernListGUID == concernID);
db.DriverConcernsLists.Remove(concern);
db.SaveChanges();
return(RedirectToAction(actionName: "DriverConcernList", controllerName: "Trailer"));
}
}
public ActionResult EditConcernList(int concernID, string concern)
{
using (TrailerEntities db = new TrailerEntities())
{
var issue = db.DriverConcernsLists.FirstOrDefault(c => c.DriverConcernListGUID == concernID);
issue.Concern = concern;
db.SaveChanges();
return(RedirectToAction(actionName: "DriverConcernList", controllerName: "Trailer"));
}
}
