public async Task<ActionResult> DeleteRow(int id) { //--------------------------------------------------------- //We add the record for real-time update - DELETE APPLIES TO ADMIN ONLY //Get the admin id string username = HttpContext.User.Identity.Name; string AdminId = db.Users.Where(x => x.UserName == username).Select(x => x.Id).FirstOrDefault(); //Now check the record RT rt = db.RT.Where(x => x.AdminId == AdminId).FirstOrDefault(); if (rt == null) { rt = new RT(); rt.AdminId = AdminId; rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Added; } else { rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Modified; } //End of realtime update - DELETE APPLIES TO ADMIN ONLY //----------------------------------------------------------- HeatTreat heatTreat = await db.HeatTreat.FindAsync(id); db.HeatTreat.Remove(heatTreat); await db.SaveChangesAsync(); var currentImage = Path.Combine(Server.MapPath("~/Attachments"), id + ".png"); try { System.IO.File.Delete(currentImage); } catch (Exception ex) { } currentImage = Path.Combine(Server.MapPath("~/Attachments"), id + "_2.png"); try { System.IO.File.Delete(currentImage); } catch (Exception ex) { } currentImage = Path.Combine(Server.MapPath("~/Attachments"), id + "_3.png"); try { System.IO.File.Delete(currentImage); } catch (Exception ex) { } currentImage = Path.Combine(Server.MapPath("~/Attachments"), id + "_4.png"); try { System.IO.File.Delete(currentImage); } catch (Exception ex) { } currentImage = Path.Combine(Server.MapPath("~/Attachments"), id + "_5.png"); try { System.IO.File.Delete(currentImage); } catch (Exception ex) { } return Content("Ok"); }
public async Task<ActionResult> AddRow(HeatTreat heatTreat, HttpPostedFileBase uImage, HttpPostedFileBase uImage2, HttpPostedFileBase uImage3, HttpPostedFileBase uImage4, HttpPostedFileBase uImage5, string Role) { if (Role.Equals("User")) { if ( heatTreat.JobCardNumber == null && heatTreat.Temperature == null && heatTreat.Load == null && heatTreat.StationNumber == null ) { ModelState.AddModelError("NoData", "Please enter some data"); } } if (Role.Equals("Admin")) { if ( heatTreat.FirstName == null && heatTreat.JobCardNumber == null && heatTreat.Temperature == null && heatTreat.Load == null && heatTreat.StationNumber == null ) { ModelState.AddModelError("NoData", "Please enter some data"); } } heatTreat.Date = DateTime.Now; heatTreat.Image = heatTreat.Image2 = heatTreat.Image3 = heatTreat.Image4 = heatTreat.Image5 = false; if (ModelState.IsValid) { //--------------------------------------------------------- //We add the record for real-time update - EDIT APPLIES TO USER AND ADMIN //Get the admin id if (Role.Equals("User")) { int OprId = heatTreat.OperatorsId.GetValueOrDefault(); //Now check the record RT rt = db.RT.Where(x => x.OperatorsId == OprId).FirstOrDefault(); if (rt == null) { rt = new RT(); rt.OperatorsId = OprId; rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Added; } else { rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Modified; } } if (Role.Equals("Admin")) { string username = HttpContext.User.Identity.Name; string AdminId = db.Users.Where(x => x.UserName == username).Select(x => x.Id).FirstOrDefault(); //Now check the record RT rt = db.RT.Where(x => x.AdminId == AdminId).FirstOrDefault(); if (rt == null) { rt = new RT(); rt.AdminId = AdminId; rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Added; } else { rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Modified; } } //End of realtime update - EDIT APPLIES TO USER AND ADMIN //----------------------------------------------------------- db.HeatTreat.Add(heatTreat); await db.SaveChangesAsync(); ViewBag.Result = "DataSaved"; bool CorrectImage = true; if (uImage != null) { var fileName = Path.GetFileName(uImage.FileName); string[] SplitFileName = fileName.Split('.'); if (SplitFileName.Count() < 2) { //ModelState.AddModelError("uImage", "No extension"); CorrectImage = false; } if (!(SplitFileName[SplitFileName.Count() - 1].Equals("jpg") || SplitFileName[SplitFileName.Count() - 1].Equals("jpeg") || SplitFileName[SplitFileName.Count() - 1].Equals("png") || SplitFileName[SplitFileName.Count() - 1].Equals("ico") || SplitFileName[SplitFileName.Count() - 1].Equals("bmp") || SplitFileName[SplitFileName.Count() - 1].Equals("gif") ) ) { //ModelState.AddModelError("uImage", "File uImage Required"); CorrectImage = false; } if (CorrectImage) { var path = Path.Combine(Server.MapPath("~/Attachments"), heatTreat.HeatTreatId + ".png"); uImage.SaveAs(path); heatTreat.Image = true; db.Entry(heatTreat).State = EntityState.Modified; await db.SaveChangesAsync(); } } //2 CorrectImage = true; if (uImage2 != null) { var fileName = Path.GetFileName(uImage2.FileName); string[] SplitFileName = fileName.Split('.'); if (SplitFileName.Count() < 2) { //ModelState.AddModelError("uImage", "No extension"); CorrectImage = false; } if (!(SplitFileName[SplitFileName.Count() - 1].Equals("jpg") || SplitFileName[SplitFileName.Count() - 1].Equals("jpeg") || SplitFileName[SplitFileName.Count() - 1].Equals("png") || SplitFileName[SplitFileName.Count() - 1].Equals("ico") || SplitFileName[SplitFileName.Count() - 1].Equals("bmp") || SplitFileName[SplitFileName.Count() - 1].Equals("gif") ) ) { //ModelState.AddModelError("uImage", "File uImage Required"); CorrectImage = false; } if (CorrectImage) { var path = Path.Combine(Server.MapPath("~/Attachments"), heatTreat.HeatTreatId + "_2.png"); uImage2.SaveAs(path); heatTreat.Image2 = true; db.Entry(heatTreat).State = EntityState.Modified; await db.SaveChangesAsync(); } } //3 CorrectImage = true; if (uImage3 != null) { var fileName = Path.GetFileName(uImage3.FileName); string[] SplitFileName = fileName.Split('.'); if (SplitFileName.Count() < 2) { //ModelState.AddModelError("uImage", "No extension"); CorrectImage = false; } if (!(SplitFileName[SplitFileName.Count() - 1].Equals("jpg") || SplitFileName[SplitFileName.Count() - 1].Equals("jpeg") || SplitFileName[SplitFileName.Count() - 1].Equals("png") || SplitFileName[SplitFileName.Count() - 1].Equals("ico") || SplitFileName[SplitFileName.Count() - 1].Equals("bmp") || SplitFileName[SplitFileName.Count() - 1].Equals("gif") ) ) { //ModelState.AddModelError("uImage", "File uImage Required"); CorrectImage = false; } if (CorrectImage) { var path = Path.Combine(Server.MapPath("~/Attachments"), heatTreat.HeatTreatId + "_3.png"); uImage3.SaveAs(path); heatTreat.Image3 = true; db.Entry(heatTreat).State = EntityState.Modified; await db.SaveChangesAsync(); } } //4 CorrectImage = true; if (uImage4 != null) { var fileName = Path.GetFileName(uImage4.FileName); string[] SplitFileName = fileName.Split('.'); if (SplitFileName.Count() < 2) { //ModelState.AddModelError("uImage", "No extension"); CorrectImage = false; } if (!(SplitFileName[SplitFileName.Count() - 1].Equals("jpg") || SplitFileName[SplitFileName.Count() - 1].Equals("jpeg") || SplitFileName[SplitFileName.Count() - 1].Equals("png") || SplitFileName[SplitFileName.Count() - 1].Equals("ico") || SplitFileName[SplitFileName.Count() - 1].Equals("bmp") || SplitFileName[SplitFileName.Count() - 1].Equals("gif") ) ) { //ModelState.AddModelError("uImage", "File uImage Required"); CorrectImage = false; } if (CorrectImage) { var path = Path.Combine(Server.MapPath("~/Attachments"), heatTreat.HeatTreatId + "_4.png"); uImage4.SaveAs(path); heatTreat.Image4 = true; db.Entry(heatTreat).State = EntityState.Modified; await db.SaveChangesAsync(); } } //5 CorrectImage = true; if (uImage5 != null) { var fileName = Path.GetFileName(uImage5.FileName); string[] SplitFileName = fileName.Split('.'); if (SplitFileName.Count() < 2) { //ModelState.AddModelError("uImage", "No extension"); CorrectImage = false; } if (!(SplitFileName[SplitFileName.Count() - 1].Equals("jpg") || SplitFileName[SplitFileName.Count() - 1].Equals("jpeg") || SplitFileName[SplitFileName.Count() - 1].Equals("png") || SplitFileName[SplitFileName.Count() - 1].Equals("ico") || SplitFileName[SplitFileName.Count() - 1].Equals("bmp") || SplitFileName[SplitFileName.Count() - 1].Equals("gif") ) ) { //ModelState.AddModelError("uImage", "File uImage Required"); CorrectImage = false; } if (CorrectImage) { var path = Path.Combine(Server.MapPath("~/Attachments"), heatTreat.HeatTreatId + "_5.png"); uImage5.SaveAs(path); heatTreat.Image5 = true; db.Entry(heatTreat).State = EntityState.Modified; await db.SaveChangesAsync(); } } int tempid = heatTreat.OperatorsId.GetValueOrDefault(); string tempname = heatTreat.FirstName; heatTreat = new HeatTreat(); ModelState.Clear(); if (Role.Equals("User")) { heatTreat.OperatorsId = tempid; heatTreat.FirstName = tempname; } } else { ViewBag.Result = "DataError"; } ViewBag.Role = Role; ViewBag.OperatorId = heatTreat.OperatorsId; ViewBag.OperatorName = heatTreat.FirstName; ViewBag.Columns = await db.ColumnNames.OrderBy(x => x.Order).Select(x => x.Label).ToListAsync(); ViewBag.ColumnsFull = await db.ColumnNames.OrderBy(x => x.Order).ToListAsync(); ViewBag.ColumnsToHideUser = await db.UserHideColumns.Where(x => x.OperatorsId == heatTreat.OperatorsId).ToListAsync(); return View("User", heatTreat); }
public async Task<ActionResult> EditRow(List<HeatTreat> heatTreat, int index) { if (ModelState.IsValid) { //--------------------------------------------------------- //We add the record for real-time update - EDIT APPLIES TO ADMIN ONLY //Get the admin id string username = HttpContext.User.Identity.Name; string AdminId = db.Users.Where(x => x.UserName == username).Select(x => x.Id).FirstOrDefault(); //Now check the record RT rt = db.RT.Where(x => x.AdminId == AdminId).FirstOrDefault(); if (rt == null) { rt = new RT(); rt.AdminId = AdminId; rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Added; } else { rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Modified; } //End of realtime update - EDIT APPLIES TO ADMIN ONLY //----------------------------------------------------------- db.Entry(heatTreat[0]).State = EntityState.Modified; await db.SaveChangesAsync(); ViewBag.Result = "DataSaved"; } else { ViewBag.Result = "DataError"; } ViewBag.num = 0; return PartialView("RowDetail", heatTreat); }
public async Task<ActionResult> Embed(string jobCardNo, string firstName, string stationNumber, string temp, string load) { HeatTreat heatTreat = new HeatTreat(); //Inject data to the model heatTreat.JobCardNumber = jobCardNo; heatTreat.FirstName = firstName; heatTreat.StationNumber = stationNumber; heatTreat.Temperature = temp; heatTreat.Load = load; heatTreat.Image = heatTreat.Image2 = heatTreat.Image3 = heatTreat.Image4 = heatTreat.Image5 = false; heatTreat.Date = DateTime.Now; //Validate the data if ( heatTreat.FirstName == null && heatTreat.JobCardNumber == null && heatTreat.Temperature == null && heatTreat.Load == null && heatTreat.StationNumber == null ) { ViewBag.Result = "DataError"; ViewBag.ResultDetail = "Please enter some data."; goto SkipSaving; } //Validate the first name Operators op = await db.Operators.Where(x => x.Number == firstName).FirstOrDefaultAsync(); if (op == null) { ViewBag.Result = "DataError"; ViewBag.ResultDetail = "Operator Number not found."; goto SkipSaving; } //Change the values heatTreat.FirstName = op.Name; heatTreat.OperatorsId = op.OperatorsId; try { //--------------------------------------------------------- //We add the record for real-time update EMBED RT rt = db.RT.Where(x => x.bitDevice == true).FirstOrDefault(); if (rt == null) { rt = new RT(); rt.bitDevice = true; rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Added; } else { rt.LastModified = DateTime.UtcNow; db.Entry(rt).State = EntityState.Modified; } //End of realtime update - EMBED //----------------------------------------------------------- db.HeatTreat.Add(heatTreat); await db.SaveChangesAsync(); ViewBag.Result = "DataSaved"; } catch (Exception ex) { ViewBag.Result = "DataError"; ViewBag.ResultDetail = "Invalid data found."; } SkipSaving: ViewBag.Role = "Embed"; ViewBag.Columns = await db.ColumnNames.OrderBy(x => x.Order).Select(x => x.Label).ToListAsync(); ViewBag.ColumnsFull = await db.ColumnNames.OrderBy(x => x.Order).ToListAsync(); ViewBag.ColumnsToHideUser = await db.UserHideColumns.Where(x => x.OperatorsId == 0).ToListAsync(); return View("User", heatTreat); }