public ActionResult Create([Bind(Include = "ID,Prevention,Responsible,ProcessDate,Date")] DSevenTable dSevenTable, string errorNo) { var userModel = common.getCurrentUserModel(); dSevenTable.ErrorNo = errorNo; dSevenTable.Company = userModel.Company; if (ModelState.IsValid) { db.DSevenTable.Add(dSevenTable); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { ViewBag.Responsible = dropDownManager.getResponsibleForD7(); return(View(dSevenTable)); } return(RedirectToAction("DSteps", "EightStep", new { errorNo = dSevenTable.ErrorNo })); } ViewBag.Responsible = dropDownManager.getResponsibleForD7(); return(View(dSevenTable)); }
public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,Machine,Method,Men,Material,Monde,OlusumNeden1,OlusumNeden2,OlusumNeden3,OlusumNeden4,OlusumNeden5,YaklanamamaNeden1,YaklanamamaNeden2,YaklanamamaNeden3,YaklanamamaNeden4,YaklanamamaNeden5")] DFourTable dFourTable) { var userModel = common.getCurrentUserModel(); var errorNo = common.getCurrentErrorNo(); dFourTable.ErrorNo = errorNo; dFourTable.Company = userModel.Company; // save images on ImgesTable fileHelper.saveImagesDB(imageFiles, "D4", errorNo); // save document on NotesTable fileHelper.saveDocumentDB(documentFiles, "D4", errorNo); if (ModelState.IsValid) { db.DFourTable.Add(dFourTable); db.SaveChanges(); return(RedirectToAction("DSteps", "EightStep", new { errorNo = dFourTable.ErrorNo })); } //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFourTable.ErrorNo); return(View(dFourTable)); }
public ActionResult Create([Bind(Include = "ID,ErrorDefine,ErrorDescription,Date,Person")] DTwoTable dTwoTable, string errorNo) { var userModel = common.getCurrentUserModel(); dTwoTable.Company = userModel.Company; dTwoTable.ErrorNo = errorNo; if (ModelState.IsValid) { db.DTwoTable.Add(dTwoTable); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { return(View(dTwoTable)); } return(RedirectToAction("DSteps", "EightStep", new { errorNo = errorNo })); } return(View(dTwoTable)); }
public ActionResult Create([Bind(Include = "ID,ErrorCode,ErrorDefine,Department,Company")] ErrorCodeTable errorCodeTable) { if (ModelState.IsValid) { db.ErrorCodeTable.Add(errorCodeTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(errorCodeTable)); }
public ActionResult Create([Bind(Include = "ID,Name,Email,Password,Department,Company,PhoneNumber,UserLevel")] UserTable userTable) { if (ModelState.IsValid) { db.UserTable.Add(userTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userTable)); }
public ActionResult Create([Bind(Include = "ID,DepertmantName,CompanyName")] DepartmentTable departmentTable) { if (ModelState.IsValid) { db.DepartmentTable.Add(departmentTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(departmentTable)); }
public ActionResult Create([Bind(Include = "ID,ErrorNo,Name,AddedPlace,ImagePath")] ImagesTable imagesTable) { if (ModelState.IsValid) { db.ImagesTable.Add(imagesTable); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", imagesTable.ErrorNo); return(View(imagesTable)); }
public ActionResult CreateUser([Bind(Include = "ID,Name,Email,Password,Department,Company,PhoneNumber,UserLevel")] UserTable userTable) { if (ModelState.IsValid) { db.UserTable.Add(userTable); db.SaveChanges(); //return RedirectToAction("Index"); return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri)); } // return View(userTable); return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri)); }
public ActionResult Create([Bind(Include = "ID,Company,Users")] SuperUserTable superUserTable) { var userModel = common.getCurrentUserModel(); if (ModelState.IsValid) { db.SuperUserTable.Add(superUserTable); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UsersList = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name");// text , value return(View(superUserTable)); }
public ActionResult Create(HttpPostedFileBase[] imageFiles, [Bind(Include = "ID,Company,CreateDate,CloseDate,Creator,ErrorSource,ErrorProduct,WaybillNo,PartNumber,PartName,ErrorNo,ErrorCode,ErrorDefine,ErrorDescription,WrongAmount,ControlledQuantity,Ppm,JunkAmount,JunkProcess,JunkType,SortingDuringProductionAmount,SortingDuringProductionType,CheckingBeforeShipmentAmount,CheckingBeforeShipmentType,SmilarFaultyAvalaible,Contact,Quarantine,QuarantineType,ReferenceNumber,Costumer")] ErrorListTable errorListTable) { var userModel = common.getCurrentUserModel(); SqlHelper sqlHelper = new SqlHelper(); // set Default values //errorListTable.CreateDate = DateTime.Now; errorListTable.ErrorNo = sqlHelper.getErrorNo(); errorListTable.Company = userModel.Company; errorListTable.CloseDate = null; errorListTable.Ppm = (errorListTable.WrongAmount * 1000000) / (errorListTable.ControlledQuantity); errorListTable.LastStep = "D0"; // "D0" errorListTable.SaveDate = DateTime.Now; // hata kodunu veri tabanına açıklamasını kaydettiği için bu kod ile düzeltme sağlayacağım var errorcode = db.ErrorCodeTable.Where(x => x.ErrorDefine == errorListTable.ErrorDefine && x.Company == userModel.Company).FirstOrDefault().ErrorCode; errorListTable.ErrorCode = errorcode; if (ModelState.IsValid) { db.ErrorListTable.Add(errorListTable); db.SaveChanges(); // Add image flie to db------------------ // save images on ImgesTable fileHelper.saveImagesDB(imageFiles, "D0", errorListTable.ErrorNo); mailHelper.sendMailForSuperUser(errorListTable.ErrorNo); // hata oluşturulunca super userlara mail gider return(RedirectToAction("Index")); } initViewBags(); return(View(errorListTable)); }
public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,ErrorType,MeasuresTaken,ProcessDate,TimeRemaining,DelayReason,Person")] DSixTable dSixTable) { var userModel = common.getCurrentUserModel(); var errorNo = common.getCurrentErrorNo(); dSixTable.ErrorNo = errorNo; dSixTable.Company = userModel.Company; if (ModelState.IsValid) { db.DSixTable.Add(dSixTable); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType(); // Precautions return(View(dSixTable)); } // save images on ImgesTable fileHelper.saveImagesDB(imageFiles, "D6", errorNo); // save document on NotesTable fileHelper.saveDocumentDB(documentFiles, "D6", errorNo); return(RedirectToAction("DSteps", "EightStep", new { errorNo = dSixTable.ErrorNo })); } ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType(); // Precautions return(View(dSixTable)); }
public void setNotificaitonAndMail(DOneTable dOneTable) { // yeni oluturulan ekip üyelerine mail ve bildirim gidecek // bildirim gitmesi: // ekip liderine gidecek mail var userTable = db.UserTable.Where(x => x.Name == dOneTable.TeamLeader).FirstOrDefault(); NotificationTable notification = new NotificationTable(); notification.Date = DateTime.Now; notification.MailAddress = userTable.Email; notification.Notification = dOneTable.ErrorNo + " nol'lu hatanın çözüm ekibi Liderisiniz"; notification.IsRead = null; notification.ErrorNo = dOneTable.ErrorNo; db.NotificationTable.Add(notification); db.SaveChanges(); // ekip üyelerine gidecek mail var teamMembers = dOneTable.TeamMembers.Split(',').ToList(); foreach (var member in teamMembers) { if (member != null) { userTable = db.UserTable.Where(x => x.Name == member).FirstOrDefault(); notification = new NotificationTable(); notification.Date = DateTime.Now; notification.MailAddress = userTable.Email; notification.Notification = dOneTable.ErrorNo + " nol'lu hatanın çözüm ekibine atandınız"; notification.IsRead = null; notification.ErrorNo = dOneTable.ErrorNo; db.NotificationTable.Add(notification); db.SaveChanges(); } } }
public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,ErrorType,Precautions,Deadline,Person")] DFiveTable dFiveTable) { var userModel = common.getCurrentUserModel(); var errorNo = common.getCurrentErrorNo(); dFiveTable.ErrorNo = errorNo; dFiveTable.Company = userModel.Company; if (ModelState.IsValid) { db.DFiveTable.Add(dFiveTable); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name");// text , value createDropDownForErrorType(); return(View(dFiveTable)); } // save images on ImgesTable fileHelper.saveImagesDB(imageFiles, "D5", errorNo); // save document on NotesTable fileHelper.saveDocumentDB(documentFiles, "D5", errorNo); return(RedirectToAction("DSteps", "EightStep", new { errorNo = dFiveTable.ErrorNo })); } //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFiveTable.ErrorNo); ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value // dropdown için errortype seçimi listesi gelicek createDropDownForErrorType(); return(View(dFiveTable)); }
public ActionResult Create([Bind(Include = "ID,TeamLeader,TeamMembers")] DOneTable dOneTable, string errorNo) { var userModel = common.getCurrentUserModel(); var tempErrorNo = common.getCurrentErrorNo(); if (tempErrorNo != errorNo) { dOneTable.ErrorNo = tempErrorNo; } else { dOneTable.ErrorNo = errorNo; } // save model to see another view if (ModelState.IsValid) { mailHelper.sendMailToUser(dOneTable); // mail gönderme işlemi yapılır dOneTable.Company = userModel.Company; // takım lideri ve takım üyelerine mail ve bildirim gidecek, takım üyeleri virgül ile ayrılmı gönderilecek sqlHelper.setNotificaitonAndMail(dOneTable); db.DOneTable.Add(dOneTable); db.SaveChanges(); return(RedirectToAction("DSteps", "EightStep", new { errorNo = errorNo })); // hata çözüm adımları sayfasına yönlendirme yapar } ViewBag.TeamLeader = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name", dOneTable.TeamLeader); ViewBag.Team = sqlHelper.getUserList(); return(View(dOneTable)); }
public void saveImagesDB(HttpPostedFileBase[] imageFiles, string addedStep, string errorNo) { var userModel = common.getCurrentUserModel(); System.IO.Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/images/" + userModel.Company)); // geçerli şirket resimlerine ait klasör yaratılır // Add image flie to db------------------ int counter = 0; foreach (var image in imageFiles) { try { counter++; ImagesTable imageTable = new ImagesTable(); imageTable.ErrorNo = errorNo; imageTable.AddedPlace = addedStep; var fileNameWithOutExtension = Path.GetFileNameWithoutExtension(image.FileName); // uzantısız adı alınır var extension = Path.GetExtension(image.FileName); // uzantısı alınır // uzantısız dosya adı illegal karakterlerden arındırıldı fileNameWithOutExtension = Regex.Replace(fileNameWithOutExtension, "[^a-zA-Z0-9_]+", "_", RegexOptions.Compiled); // dosya adı uzantısız olarak değiştirildi imageTable.Name = fileNameWithOutExtension; string filePath = "~/images/" + userModel.Company + "/" + "(" + addedStep + ")" + errorNo + "_" + counter.ToString() + "_" + fileNameWithOutExtension + extension; imageTable.ImagePath = filePath; db.ImagesTable.Add(imageTable); db.SaveChanges(); //Save the Image File in Folder. image.SaveAs(HttpContext.Current.Server.MapPath(filePath)); } catch (Exception ex) { } } }
public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,Action,TransactionDate,Date,Person")] DThreeTable dThreeTable) { var userModel = common.getCurrentUserModel(); var errorNo = common.getCurrentErrorNo(); dThreeTable.ErrorNo = errorNo; dThreeTable.Company = userModel.Company; if (ModelState.IsValid) { db.DThreeTable.Add(dThreeTable); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name");// text , value return(View(dThreeTable)); } // save images on ImgesTable fileHelper.saveImagesDB(imageFiles, "D3", errorNo); // save document on NotesTable fileHelper.saveDocumentDB(documentFiles, "D3", errorNo); return(RedirectToAction("DSteps", "EightStep", new { errorNo = dThreeTable.ErrorNo })); } //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dThreeTable.ErrorNo); ViewBag.Person = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value return(View(dThreeTable)); }
public ActionResult CompleteEightStep(string text) { var userModel = common.getCurrentUserModel(); var errorNo = common.getCurrentErrorNo(); MailHelper mailhelper = new MailHelper(); var dOneTable = db.DOneTable.Where(x => x.ErrorNo == errorNo).FirstOrDefault(); // ekip üyelerine erişmek için dOneTable a ihtiyac duyucaz // hata çözülmüş ise if (text == null) // hata kabul edilmiş ise "Tamamla" butonuna basılmış ise { // bildirimleri güncelle sqlHelper.setReadNotificationForErrorNo(errorNo); var errorListTable = db.ErrorListTable.Where(x => x.ErrorNo == errorNo).FirstOrDefault(); errorListTable.CloseDate = DateTime.Now; errorListTable.LastStep = "D8"; db.Entry(errorListTable).State = EntityState.Modified; db.SaveChanges(); var table = db.DEightTable.Where(x => x.ErrorNo == errorNo).FirstOrDefault(); if (table != null)// eğer hata kabul tablosunda daha önce var ise o veri güncellenir { // update edilir table.Company = userModel.Company; table.Date = DateTime.Now; table.RejectionReason = null; // hata kabul edildiği için reddetme yazısı null edilir db.Entry(table).State = EntityState.Modified; db.SaveChanges(); } else // daha önce hata kabul listesinde bu error no yok ise { var dEighttable = new DEightTable(); dEighttable.Company = userModel.Company; dEighttable.ErrorNo = errorNo; dEighttable.Date = DateTime.Now; dEighttable.RejectionReason = null; // hata kabul edildiği için açıklama kısmı null yapılır db.DEightTable.Add(dEighttable); db.SaveChanges(); } // hata tamalanmış ise takım üyelerine mail gönderilir mailhelper.sendCompleteErrorMail(dOneTable, "Hata Çözülmüştür", "Tebrikler"); } else // eğer reddetme yazısı var ise { // aynı error no ya ait tabloda veri var mı kontrol edilir // D8.adımı veri tabanına kaydeder sqlHelper.setRejectReadNotificationForErrorNo(errorNo);// hata kabul edilmediği için bildirimin kırmızı görünmesi sağlanır var table = db.DEightTable.Where(x => x.ErrorNo == errorNo).FirstOrDefault(); if (table != null) { // update edilir table.Company = userModel.Company; table.RejectionReason = text; table.Date = DateTime.Now; db.Entry(table).State = EntityState.Modified; db.SaveChanges(); } else // daha önce açıklama yazılmamış ise { var dEighttable = new DEightTable(); dEighttable.Company = userModel.Company; dEighttable.ErrorNo = errorNo; dEighttable.RejectionReason = text; dEighttable.Date = DateTime.Now; db.DEightTable.Add(dEighttable); db.SaveChanges(); } // hata kabul edilmemiş ise takım üyelerine mail gönderilir mailhelper.sendCompleteErrorMail(dOneTable, "Hata Çözülmedi !!!", text); } return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri)); }