public ActionResult Create(T_Type T_Type) { ViewBag.TY_CategoryID = new SelectList(_db.T_Category, "CategoryID", "CA_NameCategory"); if (ModelState.IsValid) { var chk = _db.T_Type.FirstOrDefault(c => c.TypeID == T_Type.TypeID); if (chk == null) { var p = int.TryParse(T_Type.TypeID, out _); if (p) { _db.T_Type.Add(T_Type); _db.SaveChanges(); Session["Result"] = "okC"; return(RedirectToAction("Index")); } else { ModelState.AddModelError("TypeID", "กรุณากรอกเป็นตัวเลข"); return(View(T_Type)); } } else { ModelState.AddModelError("TypeID", "มีหมวดนี้อยู่ในฐานข้อมูลแล้ว กรุณาตรวจสอบอีกครั้ง"); } } return(View(T_Type)); }
public ActionResult Create(T_Category t_Category) { if (ModelState.IsValid) { var chk = _db.T_Category.FirstOrDefault(c => c.CategoryID == t_Category.CategoryID); if (chk == null) { var p = int.TryParse(t_Category.CategoryID, out _); if (p) { _db.T_Category.Add(t_Category); _db.SaveChanges(); Session["Result"] = "okC"; return(RedirectToAction("Index")); } else { ModelState.AddModelError("CategoryID", "กรุณากรอกเป็นตัวเลข"); return(View(t_Category)); } } else { ModelState.AddModelError("CategoryID", "มีหมวดนี้อยู่ในฐานข้อมูลแล้ว กรุณาตรวจสอบอีกครั้ง"); return(View(t_Category)); } } return(View(t_Category)); }
public ActionResult Create([Bind(Include = "StatusID,Status_Name")] T_Status t_Status) { if (ModelState.IsValid) { _db.T_Status.Add(t_Status); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(t_Status)); }
public ActionResult Create(T_DistributorList data) { try { _db.T_DistributorList.Add(data); _db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View(data)); } }
public ActionResult Create(T_Place data) { if (ModelState.IsValid) { var chk = _db.T_Place.FirstOrDefault(c => c.PlaceID == data.PlaceID); if (chk == null) { _db.T_Place.Add(data); _db.SaveChanges(); Session["Result"] = "okC"; return(RedirectToAction("Index")); } else { ModelState.AddModelError("CategoryID", "มีหมวดนี้อยู่ในฐานข้อมูลแล้ว กรุณาตรวจสอบอีกครั้ง"); } } return(View(data)); }
public ActionResult Disbu(string DL) { if (DL != null) { var data = _db.T_Distributor.ToList(); var Ex = data.FirstOrDefault(a => a.DistributorID == DL); if (Ex != null) { Ex.Di_Status = "2"; _db.Entry(Ex).State = EntityState.Modified; _db.SaveChanges(); Chang(DL); } return(RedirectToAction(nameof(IndexR))); } else { Session["Result"] = "error8"; return(RedirectToAction(nameof(IndexR))); } }
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 Create(T_Requisition data) { ConvertDate convertD = new ConvertDate(); var data1 = _db.Teacher.ToList(); var dateNow = convertD.ThaiDate(data.Re_DateRequi); data.Re_DateRequi = Convert.ToDateTime(dateNow); var value = new List <TmpTeacher>(); foreach (var item in data1) { value.Add(new TmpTeacher { IDT = item.TeaId, NAMEFULL = item.Title.TName + " " + item.TeaName }); } ViewBag.Re_TeaId = new SelectList(value, "IDT", "NAMEFULL"); if (Convert.ToInt32(data.RequisitionID) < 0) { ModelState.AddModelError("RequisitionID", "กรุณาตรวจสอบ กรุณากรอกอีกครั้ง"); return(View(data)); } var Chk = _db.T_Requisition.Where(x => x.RequisitionID == data.RequisitionID).ToList(); if (ModelState.IsValid) { try { var p = int.TryParse(data.RequisitionID, out _); if (p) { var Year = DateTime.Now.ToString("yy"); data.RequisitionID = data.RequisitionID + "/" + Year; if (Chk.Count == 0) { data.Re_StepID = "0"; _db.T_Requisition.Add(data); _db.SaveChanges(); Session["Result"] = "okC"; Session["RequisitionID"] = data.RequisitionID; return(RedirectToAction("Waiting", "Requisition")); } else { ViewBag.Re_TeaId = new SelectList(value, "IDT", "NAMEFULL"); ModelState.AddModelError("RequisitionID", "เลขใบเบิกซ้ำ"); return(View(data)); } } else { ModelState.AddModelError("RequisitionID", "กรุณากรอกเลขที่ใบเบิกเป็นตัวเลข"); return(View(data)); } } catch { ModelState.AddModelError("RequisitionID", "เลขใบเบิกซ้ำ"); return(View(data)); } } else { return(View(data)); } }