public void Save(T_Type value, ref string msg)
{
T_Type valueupdate = new T_Type();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_Types.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Code: {1}" + Environment.NewLine + "Type of room: {2}", SystemProperties.MessageNotification.Saved, value.Code, value.Type);
}
else
{
valueupdate = dc.T_Types.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.Code = value.Code;
valueupdate.Type = value.Type;
valueupdate.Active = value.Active;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Code: {1}" + Environment.NewLine + "Type of room: {2}", SystemProperties.MessageNotification.Updated, valueupdate.Code, valueupdate.Type);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
public bool Compare(T_Type value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Types.Where(x => x.Active == value.Active && x.Code.ToLower() == value.Code.ToLower() && x.Type.ToLower() == value.Type.ToLower()).FirstOrDefault() == null ? true : false);
}
}
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));
}
private T_Type SetRoomType()
{
T_Type valueRet = new T_Type();
valueRet.ID = isAdd ? 0 : Convert.ToInt64(dgRoomType.SelectedRows[0].Cells[0].Value.ToString());
valueRet.Code = txtCode.Text;
valueRet.Type = txtRoomType.Text;
valueRet.Active = cbActive.Checked;
return(valueRet);
}
public void Delete(T_Type value, ref string msg)
{
T_Type valuedelete = new T_Type();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Types.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_Types.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Code: {1}" + Environment.NewLine + "Type of room: {2}", SystemProperties.MessageNotification.Deleted, valuedelete.Code, valuedelete.Type);
}
}
// GET: T_Category/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
T_Type T_Type = _db.T_Type.Find(id);
if (T_Type != null)
{
ViewBag.TY_CategoryID = new SelectList(_db.T_Category, "CategoryID", "CA_NameCategory", T_Type.TypeID);
}
return(View(T_Type));
}
// GET: T_Category/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
T_Type T_Type = _db.T_Type.Find(id);
if (T_Type == null)
{
return(HttpNotFound());
}
return(View(T_Type));
}
public ActionResult Edit(T_Type T_Type)
{
ViewBag.TY_CategoryID = new SelectList(_db.T_Category, "CategoryID", "CA_NameCategory", T_Type.TypeID);
if (ModelState.IsValid)
{
var p = int.TryParse(T_Type.TypeID, out _);
if (p)
{
_db.Entry(T_Type).State = EntityState.Modified;
_db.SaveChanges();
Session["Result"] = "okE";
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("TypeID", "กรุณากรอกเป็นตัวเลข");
return(View());
}
}
return(View(T_Type));
}
public static T_Type CreateT_Type(int ID, string name)
{
T_Type t_Type = new T_Type();
t_Type.ID = ID;
t_Type.Name = name;
return t_Type;
}
public void AddToT_Type(T_Type t_Type)
{
base.AddObject("T_Type", t_Type);
}
