// eğer hata kabul edildi ise bildirimler yeşil görünecek bunu ayarlar
public void setReadNotificationForErrorNo(string currentErrorNo)
{
// aynı error no'ya ait bütün bildirimler çekilir
var notifList = db.NotificationTable.Where(x => x.ErrorNo == currentErrorNo).ToList();
// bu bildirimler okundu olarak update edilir
foreach (var notif in notifList)
{
notif.IsRead = true;
db.Entry(notif).State = EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "ID,ErrorNo,ErrorType,Precautions,Deadline,Person")] DFiveTable dFiveTable)
{
var userModel = common.getCurrentUserModel();
dFiveTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dFiveTable).State = EntityState.Modified;
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));
}
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 Edit([Bind(Include = "ID,ErrorNo,ErrorType,MeasuresTaken,ProcessDate,TimeRemaining,DelayReason,Person")] DSixTable dSixTable)
{
var userModel = common.getCurrentUserModel();
dSixTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dSixTable).State = EntityState.Modified;
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));
}
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 ActionResult Edit([Bind(Include = "ID,Name,Email,Password,Department,Company,PhoneNumber,UserLevel")] UserTable userTable)
{
if (ModelState.IsValid)
{
db.Entry(userTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userTable));
}
public ActionResult Edit([Bind(Include = "ID,DepertmantName,CompanyName")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.Entry(departmentTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentTable));
}
public ActionResult Edit([Bind(Include = "ID,ErrorCode,ErrorDefine,Department,Company")] ErrorCodeTable errorCodeTable)
{
if (ModelState.IsValid)
{
db.Entry(errorCodeTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(errorCodeTable));
}
public ActionResult Edit([Bind(Include = "ID,ErrorNo,Name,AddedPlace,ImagePath")] ImagesTable imagesTable)
{
if (ModelState.IsValid)
{
db.Entry(imagesTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", imagesTable.ErrorNo);
return(View(imagesTable));
}
public ActionResult Edit([Bind(Include = "ID,Company,Users")] SuperUserTable superUserTable)
{
var userModel = common.getCurrentUserModel();
if (ModelState.IsValid)
{
db.Entry(superUserTable).State = EntityState.Modified;
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 Edit([Bind(Include = "ID,ErrorNo,Machine,Method,Men,Material,Monde,OlusumNeden1,OlusumNeden2,OlusumNeden3,OlusumNeden4,OlusumNeden5,YaklanamamaNeden1,YaklanamamaNeden2,YaklanamamaNeden3,YaklanamamaNeden4,YaklanamamaNeden5")] DFourTable dFourTable)
{
var userModel = common.getCurrentUserModel();
dFourTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dFourTable).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
return(RedirectToAction("DSteps", "EightStep", new { errorNo = dFourTable.ErrorNo }));
}
//ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFourTable.ErrorNo);
return(View(dFourTable));
}
public ActionResult Edit([Bind(Include = "ID,TeamLeader,TeamMembers,ErrorNo")] DOneTable dOneTable)
{
var userModel = common.getCurrentUserModel();
dOneTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dOneTable).State = EntityState.Modified;
db.SaveChanges();
// tablodan veriler silinice notification refresh edilir
// ekip düzenlenince bildirimler de güncellenicek
mailHelper.sendMailToUserEditTeam(dOneTable); // mail gönderme işlemi yapılır
sqlHelper.editNotification(dOneTable);
return(RedirectToAction("DSteps", "EightStep", new { errorNo = dOneTable.ErrorNo }));
}
ViewBag.TeamLeader = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name", dOneTable.TeamLeader);
return(View(dOneTable));
}
public ActionResult Edit([Bind(Include = "ID,ErrorNo,Prevention,Responsible,ProcessDate,Date")] DSevenTable dSevenTable)
{
var userModel = common.getCurrentUserModel();
dSevenTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dSevenTable).State = EntityState.Modified;
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 Edit([Bind(Include = "ID,Company,Contact,CreateDate,CloseDate,Creator,ErrorSource,ErrorProduct,WaybillNo,PartNumber,PartName,ErrorNo,ErrorCode,ErrorDefine,ErrorDescription,WrongAmount,ControlledQuantity,Ppm,JunkAmount,JunkProcess,JunkType,Quarantine,QuarantineType,SortingDuringProductionAmount,SortingDuringProductionType,CheckingBeforeShipmentAmount,CheckingBeforeShipmentType,SmilarFaultyAvalaible,LastStep,SaveDate,ReferenceNumber,Costumer")] ErrorListTable errorListTable)
{
var userModel = common.getCurrentUserModel();
// 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;
errorListTable.Ppm = (errorListTable.WrongAmount * 1000000) / (errorListTable.ControlledQuantity); // ppm tekrar hesaplandı
if (ModelState.IsValid)
{
db.Entry(errorListTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
initViewBags();
return(View(errorListTable));
}
public ActionResult Edit([Bind(Include = "ID,ErrorDefine,ErrorDescription,Date,Person,ErrorNo")] DTwoTable dTwoTable)
{
var userModel = common.getCurrentUserModel();
dTwoTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dTwoTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
return(View(dTwoTable));
}
return(RedirectToAction("DSteps", "EightStep", new { errorNo = dTwoTable.ErrorNo }));
}
return(View(dTwoTable));
}
public ActionResult Edit([Bind(Include = "ID,ErrorNo,Action,TransactionDate,Date,Person")] DThreeTable dThreeTable)
{
var userModel = common.getCurrentUserModel();
dThreeTable.Company = userModel.Company;
if (ModelState.IsValid)
{
db.Entry(dThreeTable).State = EntityState.Modified;
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));
}
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));
}
