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