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