public ActionResult Create(T_RequestList data) { ViewBag.RL_CategoryID = new SelectList(_db.T_Category, "CategoryID", "CA_NameCategory"); ViewBag.RL_TypeID = new SelectList(_db.T_Type, "TypeID", "TY_NameType"); ViewBag.RL_PlaceID = new SelectList(_db.T_Place, "PlaceID", "PL_NamePlace"); var chk = _db.T_Requisition.FirstOrDefault(x => x.RequisitionID == data.RL_RequisitionID); if (data.RL_Amount < 1) { ModelState.AddModelError("RL_Amount", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else if (data.RL_OnStart < 1) { ModelState.AddModelError("RL_OnStart", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else if (data.RL_Price < 1) { ModelState.AddModelError("RL_Price", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else { if (ModelState.IsValid) { if (chk != null) { if (data.ImageUpload != null) { string fileName = Path.GetFileNameWithoutExtension(data.ImageUpload.FileName); string extension = Path.GetExtension(data.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; data.RL_PictureKhru = "~/Images/" + fileName; data.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/Images/"), fileName)); } var str = DateTime.Now.ToString("yy"); var TmpCODE = ""; for (int i = 0; i < data.RL_Amount; i++) { TmpCODE = data.RL_CategoryID + "." + data.RL_TypeID + "." + (data.RL_OnStart + i) + "/" + str; } var _VALUE = _db.T_RequestList.ToList(); List <string> list = new List <string>(); List <string> ListCK = new List <string>(); int p = 0; foreach (var item in _VALUE) { p++; list.Add(item.RL_CategoryID + "." + item.RL_TypeID + "." + (item.RL_OnStart + p) + "/" + chk.Re_DateRequi.Value.ToString("yy")); } for (int i = 0; i < data.RL_Amount; i++) { ListCK.Add(data.RL_CategoryID + "." + data.RL_TypeID + "." + (data.RL_OnStart + i) + "/" + chk.Re_DateRequi.Value.ToString("yy")); } int X = 0; foreach (var item in list) { foreach (var item2 in ListCK) { if (item2 == item) { X++; } } } if (X == 0) { _db.T_RequestList.Add(data); _db.SaveChanges(); Session["Result"] = "okC"; return(RedirectToAction("Details", "Requisition", new { RequisitionID = data.RL_RequisitionID })); } else { ModelState.AddModelError("RL_OnStart", "เลขครุภัณฑ์ซ้ำ กรุณาตรวจสอบอีกครั้ง"); } } else { ModelState.AddModelError("RL_RequisitionID", "ไม่พบข้อมูลเลขการเบิก"); } } } return(View(data)); }
public ActionResult Edit(T_RequestList data) { ViewBag.RL_CategoryID = new SelectList(_db.T_Category, "CategoryID", "CA_NameCategory", data.RL_CategoryID); ViewBag.RL_TypeID = new SelectList(_db.T_Type, "TypeID", "TY_NameType", data.RL_TypeID); ViewBag.RL_PlaceID = new SelectList(_db.T_Place, "PlaceID", "PL_NamePlace", data.RL_PlaceID); var value = _db.T_RequestList.Where(a => a.RL_CategoryID == data.RL_CategoryID && a.RL_TypeID == data.RL_TypeID && a.RL_RequisitionID != data.RL_RequisitionID).ToList(); List <string> Tmp_CHK = new List <string>(); List <string> Add_CHK = new List <string>(); foreach (var item in value) { for (int i = 0; i < item.RL_Amount; i++) { Tmp_CHK.Add(item.RL_CategoryID + item.RL_TypeID + i); } } for (int i = 0; i < data.RL_Amount; i++) { Add_CHK.Add(data.RL_CategoryID + data.RL_TypeID + i); } int P = 0; foreach (var Lopdb in Tmp_CHK) { foreach (var lopCn in Add_CHK) { if (Lopdb == lopCn) { P++; } } } if (data.RL_Amount < 1) { ModelState.AddModelError("RL_Amount", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else if (data.RL_OnStart < 1) { ModelState.AddModelError("RL_OnStart", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else if (data.RL_Price < 1) { ModelState.AddModelError("RL_Price", "กรุณากรอกข้อมูล ให้มากกว่า 0"); } else { if (P == 0) { if (data.ImageUpload != null) { string fileName = Path.GetFileNameWithoutExtension(data.ImageUpload.FileName); string extension = Path.GetExtension(data.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; data.RL_PictureKhru = "~/Images/" + fileName; data.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/Images/"), fileName)); } if (ModelState.IsValid) { _db.Entry(data).State = EntityState.Modified; _db.SaveChanges(); Session["Result"] = "okE"; return(RedirectToAction("Details", "Requisition", new { RequisitionID = data.RL_RequisitionID })); } } ModelState.AddModelError("RL_OnStart", "ข้อมูลนี้มีอยู่ในฐานข้อมูลแล้ว กรุณาตรวจสอบอีกครั้ง"); } return(View(data)); }