public ActionResult Update(RubberRoller rubberRoller)
{
try
{
// Check if roller ID exist from DB
var dbRoller = _db.rubberRollers.Where(r => r.rollerID == rubberRoller.rollerID && r.id != rubberRoller.id).FirstOrDefault();
if (dbRoller != null)
{
ViewData["rollerCatList"] = getRollerCategories();
ModelState.AddModelError("rollerID", "There is already an existing roller with the same roller ID.");
return(View("CreateEditForm", rubberRoller));
}
// Retrieve existing specific rubber roller from database
RubberRoller rubberRoll = _db.rubberRollers.SingleOrDefault(c => c.id == rubberRoller.id);
if (rubberRoll == null)
{
return(RedirectToAction("Index"));
}
// Update rubber roller details
if (rubberRoll.rollerID != rubberRoller.rollerID)
{
rubberRoll.rollerID = rubberRoller.rollerID;
}
rubberRoll.rollerCategoryID = rubberRoller.rollerCategoryID;
rubberRoll.type = rubberRoller.type;
rubberRoll.usage = rubberRoller.usage;
rubberRoll.shoreHardness = rubberRoller.shoreHardness;
rubberRoll.depthOfGroove = rubberRoller.depthOfGroove;
rubberRoll.diameter = rubberRoller.diameter;
rubberRoll.condition = rubberRoller.condition;
rubberRoll.remark = rubberRoller.remark;
rubberRoll.status = rubberRoller.status;
int result = _db.SaveChanges();
if (result > 0)
{
LogAction.log(this._controllerName, "POST", "Updated roller record", User.Identity.GetUserId());
TempData["formStatus"] = true;
TempData["formStatusMsg"] = "<b>STATUS</b>: Rubber roller details has been successfully updated!";
}
return(Redirect(Request.UrlReferrer.ToString()));
}
catch (Exception ex)
{
LogAction.log(this._controllerName, "POST", "Error: " + ex.Message, User.Identity.GetUserId());
TempData["formStatus"] = false;
TempData["formStatusMsg"] = "<b>ALERT</b>: Oops! Something went wrong. The rubber roller has not been successfully updated.";
return(Redirect(Request.UrlReferrer.ToString()));
}
}
public ActionResult CreateSchedule(int?id)
{
RubberRoller rubberRoller = _db.rubberRollers.FirstOrDefault(r => r.id == id);
if (rubberRoller == null || rubberRoller.status != RollerStatus.getStatus(RollerStatus.IN_STORE_ROOM))
{
return(RedirectToAction("CreateSearch"));
}
ViewData["roller"] = rubberRoller;
LogAction.log(this._controllerName, "GET", "Requested Schedule-CreateSchedule webpage", User.Identity.GetUserId());
return(View("ScheduleCreateEditForm"));
}
public ActionResult CreateConfirm(FormCollection collection, HttpPostedFileBase file)
{
try
{
Maintenance maintenance = new Maintenance();
int rollID = Int32.Parse(collection["rollerID"]);
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rollID);
if (rubber == null)
{
return(RedirectToAction("CreateSearch"));
}
maintenance.title = collection["title"];
maintenance.rollerID = rubber.id;
maintenance.RubberRoller = rubber;
maintenance.sendTo = collection["sendTo"];
maintenance.diameterRoller = Double.Parse(collection["diameterRoller"]);
maintenance.diameterCore = Double.Parse(collection["diameterCore"]);
if (collection["openingStockDate"].Length > 0)
{
maintenance.openingStockDate = DateTime.Parse(collection["openingStockDate"]);
}
else
{
maintenance.openingStockDate = null;
}
maintenance.lastProductionLine = collection["lastProdLine"];
maintenance.totalMileage = (collection["totalMileage"] == "0" ? 0 : Int32.Parse(collection["totalMileage"]));
maintenance.reason = collection["reason"];
maintenance.remark = collection["remark"];
maintenance.newDiameter = Double.Parse(collection["newDiameter"]);
maintenance.newShoreHardness = collection["newShoreHardness"];
maintenance.correctiveAction = collection["correctiveAction"];
maintenance.sendForRefurbished = Boolean.Parse(collection["sendForRefurbished"]);
maintenance.reportDateTime = DateTime.Now;
if (file != null && file.ContentLength > 0 && imgFormats.Any(item => file.FileName.EndsWith(item, StringComparison.OrdinalIgnoreCase)))
{
maintenance.imagePath = UploadImage(file);
}
LogAction.log(this._controllerName, "GET", "Redirect Maintenance-CreateConfirm webpage", User.Identity.GetUserId());
return(View(maintenance));
}
catch (Exception ex)
{
LogAction.log(this._controllerName, "POST", $"Error: {ex.Message}", User.Identity.GetUserId());
return(RedirectToAction("CreateSearch"));
}
}
public ActionResult CreateSchedule(Schedule schedule, FormCollection collection)
{
Schedule existingSched = _db.schedules.FirstOrDefault(s => s.rollerID == schedule.rollerID && s.startDateTime == schedule.startDateTime && s.operationLine == schedule.operationLine);
if (existingSched != null)
{
ViewData["schedule"] = existingSched;
return(View("BeforeChecklist"));
}
RubberRoller rubberRoller = _db.rubberRollers.FirstOrDefault(r => r.id == schedule.rollerID);
schedule.RubberRoller = rubberRoller;
schedule.tinplateSize = $"{collection["thickness"]}x{collection["width"]}x{collection["length"]}";
schedule.status = ScheduleStatus.PENDING_BEFORE_CHECKLIST;
schedule.RubberRoller.status = RollerStatus.getStatus(RollerStatus.IN_USE);
// Update roller opening stock date
if (rubberRoller.opening_stock_date == null || rubberRoller.isRefurbished)
{
rubberRoller.opening_stock_date = DateTime.Now;
}
// Reset roller isRefurbish status
if (rubberRoller.isRefurbished)
{
rubberRoller.isRefurbished = false;
}
_db.schedules.Add(schedule);
int result = _db.SaveChanges();
if (result > 0)
{
TempData["formStatus"] = true;
TempData["formStatusMsg"] = "<b>STATUS</b>: New schedule record has been successfully added.";
ViewData["schedule"] = schedule;
LogAction.log(this._controllerName, "POST", "New schedule details successfully added", User.Identity.GetUserId());
return(View("BeforeChecklist"));
}
else
{
TempData["formStatus"] = false;
TempData["formStatusMsg"] = "<b>ALERT</b>: Oops! Something went wrong. The schedule record has not been successfully added.";
LogAction.log(this._controllerName, "POST", "Errpr adding wew schedule detail.", User.Identity.GetUserId());
return(Redirect(Request.UrlReferrer.ToString()));
}
}
public ActionResult StockCard(RubberRoller rubberRoller, int?i)
{
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rubberRoller.id);
if (rubber == null)
{
return(RedirectToAction("StockCardSearch"));
}
LogAction.log(this._controllerName, "GET", $"Requested stock card for Roller: {rubber.id}", User.Identity.GetUserId());
ViewData["rollerID"] = rubber.rollerID;
List <RollerLocation> rollerLocations = rubber.RollerLocations.ToList();
return(View(rollerLocations.ToPagedList(i ?? 1, 40)));
}
public ActionResult LocationHistory(int id, int?i)
{
if (id == 0)
{
return(RedirectToAction("Index"));
}
LogAction.log(this._controllerName, "GET", $"Requested webpage RubberRoller-LocationHistory for Roller: {id}", User.Identity.GetUserId());
RubberRoller rubberRollers = _db.rubberRollers.FirstOrDefault(r => r.id == id);
ViewData["rollerID"] = rubberRollers.rollerID;
List <RollerLocation> rollerLocations = rubberRollers.RollerLocations.ToList();
return(View(rollerLocations.ToPagedList(i ?? 1, 40)));
}
// GET: Returns create form
public ActionResult Create(RubberRoller rubberRoller)
{
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rubberRoller.id);
if (rubber == null ||
(rubber.status != RollerStatus.getStatus(RollerStatus.IN_STORE_ROOM) &&
rubber.status != RollerStatus.getStatus(RollerStatus.IN_STORE_ROOM_ON_HOLD)
)
)
{
return(RedirectToAction("CreateSearch"));
}
ViewData["rubber"] = rubber;
LogAction.log(this._controllerName, "GET", "Requested Maintenance-Create form webpage", User.Identity.GetUserId());
return(View("CreateEditMaintenance"));
}
public ActionResult MaintenanceHistory(int id, int?i)
{
if (id == 0)
{
return(RedirectToAction("Index"));
}
LogAction.log(this._controllerName, "GET", $"Requested webpage RubberRoller-MaintenanceHistory for Roller: {id}", User.Identity.GetUserId());
RubberRoller rubberRollers = _db.rubberRollers.FirstOrDefault(r => r.id == id);
ViewData["rollerID"] = rubberRollers.rollerID;
List <Maintenance> maintenances = rubberRollers.Maintenances
.Where(m => m.rollerID == id)
.Where(m => m.status == RollerMaintenance.APPROVED || m.status == RollerMaintenance.COMPLETED)
.ToList();
return(View(maintenances.ToPagedList(i ?? 1, 40)));
}
public ActionResult OperationHistory(int id, int?i)
{
if (id == 0)
{
return(RedirectToAction("Index"));
}
LogAction.log(this._controllerName, "GET", $"Requested webpage RubberRoller-OperationHistory for Roller: {id}", User.Identity.GetUserId());
RubberRoller rubberRollers = _db.rubberRollers.FirstOrDefault(r => r.id == id);
ViewData["rollerID"] = rubberRollers.rollerID;
List <Schedule> schedules = rubberRollers.Schedules
.Where(o => o.status == ScheduleStatus.COMPLETED)
.OrderBy(o => o.startDateTime)
.ToList();
return(View(schedules.ToPagedList(i ?? 1, 40)));
}
public ActionResult Create(RubberRoller rubberRoller, FormCollection collection)
{
// Check if roller ID exist from DB
var dbRoller = _db.rubberRollers.Where(r => r.rollerID == rubberRoller.rollerID).FirstOrDefault();
if (dbRoller != null)
{
ModelState.AddModelError("rollerID", "There is already an existing roller with the same roller ID.");
}
if (!ModelState.IsValid || dbRoller != null)
{
ViewData["rollerCatList"] = getRollerCategories();
return(View("CreateEditForm", rubberRoller));
}
rubberRoller.isRefurbished = false;
_db.rubberRollers.Add(rubberRoller);
// Create initial rubber roller location
RollerLocation rollerLocation = new RollerLocation();
rollerLocation.dateTimeIn = DateTime.Now;
rollerLocation.rollerID = rubberRoller.id;
rollerLocation.RubberRoller = rubberRoller;
rollerLocation.location = collection["rollLocat"];
_db.rollerLocations.Add(rollerLocation);
int result = _db.SaveChanges();
if (result > 0)
{
LogAction.log(this._controllerName, "POST", "Added new rubber roller", User.Identity.GetUserId());
TempData["formStatus"] = true;
TempData["formStatusMsg"] = "<b>STATUS</b>: New rubber roller has been successfully added!";
}
else
{
LogAction.log(this._controllerName, "POST", "Error adding new rubber roller", User.Identity.GetUserId());
TempData["formStatus"] = false;
TempData["formStatusMsg"] = "<b>ALERT</b>: Oops! Something went wrong. The rubber roller has not been successfully added.";
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public ActionResult RollerUsage(RubberRoller rubberRoller, int?i)
{
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rubberRoller.id);
if (rubber == null)
{
return(RedirectToAction("RollerUsageSearch"));
}
LogAction.log(this._controllerName, "GET", $"Requested roller usage report for Roller: {rubber.rollerID}", User.Identity.GetUserId());
RubberRoller rubberRollers = _db.rubberRollers.FirstOrDefault(r => r.id == rubber.id);
ViewData["rollerID"] = rubberRollers.rollerID;
List <Schedule> schedules = rubberRollers.Schedules
.Where(o => o.status == ScheduleStatus.COMPLETED)
.OrderBy(o => o.startDateTime)
.ToList();
return(View(schedules.ToPagedList(i ?? 1, 40)));
}
public ActionResult RollerMaintenance(RubberRoller rubberRoller, int?i)
{
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rubberRoller.id);
if (rubber == null)
{
return(RedirectToAction("RollerMaintenanceSearch"));
}
LogAction.log(this._controllerName, "GET", $"Requested roller maintenance history report for Roller: {rubber.rollerID}", User.Identity.GetUserId());
RubberRoller rubberRollers = _db.rubberRollers.FirstOrDefault(r => r.id == rubber.id);
ViewData["rollerID"] = rubberRollers.rollerID;
List <Maintenance> maintenances = rubberRollers.Maintenances
.Where(m => m.rollerID == rubber.id)
.Where(m => m.status == KJCFRubberRoller.Models.RollerMaintenance.APPROVED || m.status == KJCFRubberRoller.Models.RollerMaintenance.COMPLETED)
.ToList();
return(View(maintenances.ToPagedList(i ?? 1, 40)));
}
public static bool UpdateRollerLocation(RubberRoller rubberRoller, string location)
{
ApplicationDbContext _db = new ApplicationDbContext();
RubberRoller rubber = _db.rubberRollers.FirstOrDefault(r => r.id == rubberRoller.id);
if (rubber == null)
{
return(false);
}
// Update roller location
RollerLocation currentLocation = rubber.RollerLocations.LastOrDefault();
if (currentLocation != null)
{
currentLocation.dateTimeOut = DateTime.Now;
}
RollerLocation rollerLocation = new RollerLocation();
rollerLocation.dateTimeIn = DateTime.Now;
rollerLocation.rollerID = rubber.id;
rollerLocation.RubberRoller = rubber;
rollerLocation.location = location;
if (location.StartsWith("Operation Line"))
{
rollerLocation.operationLine = int.Parse(location.Substring(15));
}
else
{
rollerLocation.operationLine = 0;
}
// Add new records
_db.rollerLocations.Add(rollerLocation);
var result = _db.SaveChanges();
return(result > 0 ? true : false);
}
// GET: Returns edit form with existing rubber roller data
public ActionResult Edit(int?id)
{
// Ensure ID is supplied
if (id == null)
{
return(RedirectToAction("Index"));
}
// Retrieve existing specific roller category from database
RubberRoller rubberRoller = _db.rubberRollers.SingleOrDefault(c => c.id == id);
// Ensure the retrieved value is not null
if (rubberRoller == null)
{
return(RedirectToAction("Index"));
}
LogAction.log(this._controllerName, "GET", string.Format("Requested RubberRoller-Edit {0} webpage", id), User.Identity.GetUserId());
// Retrieve roller category
ViewData["rollerCatList"] = getRollerCategories();
return(View("CreateEditForm", rubberRoller));
}
