public ActionResult Create([Bind(Include = "ID_LOAITK,TEN_LOAITK,MUC_DATDUOC")] LOAITAIKHOAN s)
{
if (ModelState.IsValid)
{
db.LOAITAIKHOANs.Add(s);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(s));
}
// GET: LoaiTKKH/Edit/5
public ActionResult Edit(int id)
{
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LOAITAIKHOAN s = db.LOAITAIKHOANs.Find(id);
if (s == null)
{
return(HttpNotFound());
}
return(View(s));
}
public ActionResult Edit(LOAITAIKHOAN s)
{
int id = int.Parse(Url.RequestContext.RouteData.Values["id"].ToString());
var check = db.LOAITAIKHOANs.Where(l => l.MUC_DATDUOC == s.MUC_DATDUOC).FirstOrDefault();
if (check != null)
{
ViewBag.ErrorContent = "Mức đạt được bị trùng.";
return(View(s));
}
var updateType = db.LOAITAIKHOANs.Where(l => l.ID_LOAITK == id).FirstOrDefault();
updateType.TEN_LOAITK = s.TEN_LOAITK;
updateType.MUC_DATDUOC = s.MUC_DATDUOC;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//public LOAITAIKHOAN GetTypeUserByID(int ID)
//{
// return db.LOAITAIKHOANs.Where(x => x.LOAITAIKHOAN_ID == ID).SingleOrDefault();
//}
public int SaveData(LoaitaiKhoanModel x, string user)
{
try
{
var typeUser = db.LOAITAIKHOANs.Find(x.IDLOAITAIKHOAN);
if (typeUser != null)
{
LOAITAIKHOAN dao = db.LOAITAIKHOANs.SingleOrDefault(m => m.IS_DELETE == false && m.ID == x.IDLOAITAIKHOAN);
dao.ID = x.IDLOAITAIKHOAN;
dao.TENLOAITK = x.TENLOAITAIKHOAN;
dao.IS_DELETE = false;
dao.MODIFILEDDATE = DateTime.Now.Date;
dao.MODIFILEDBY = user;
dao.GHICHU_LOAITAIKHOAN = x.GHICHU;
db.SaveChanges();
return(1);
}
else
{
LOAITAIKHOAN dao = new LOAITAIKHOAN();
dao.IS_DELETE = false;
dao.ID = x.IDLOAITAIKHOAN;
dao.TENLOAITK = x.TENLOAITAIKHOAN;
dao.CREATEDATE = DateTime.Now.Date;
dao.CREATEBY = user;
dao.GHICHU_LOAITAIKHOAN = x.GHICHU;
db.LOAITAIKHOANs.Add(dao);
db.SaveChanges();
return(2);
}
}
catch
{
return(0);
}
}
public int ktDangNhap(string username, string pass)
{
TAIKHOAN obj = linqToMySQL.TAIKHOANs.Where(t => t.TAIKHOAN1.Trim() == username && t.MATKHAU.Trim() == pass).Select(t => t).FirstOrDefault();
if (obj != null)
{
LOAITAIKHOAN loai = linqToMySQL.LOAITAIKHOANs.Where(t => t.MALOAITK == obj.MALOAITK).Select(t => t).FirstOrDefault();
if (loai.TENLOAI.Trim() == "2")
{
return(0);
}
NHANVIEN nv = linqToMySQL.NHANVIENs.Where(t => t.TAIKHOAN == obj.TAIKHOAN1).Select(t => t).FirstOrDefault();
CHUCVU cv = linqToMySQL.CHUCVUs.Where(t => t.MACHUCVU == nv.MACHUCVU).Select(t => t).FirstOrDefault();
if (cv.TENCHUCVU.Trim() == "quản lý")
{
return(1);
}
else
{
return(2);
}
}
return(-1);
}
