public bool UpdateOrder(int id, int status)
{
var Order = db.ORDERs.Find(id);
if (Order != null)
{
Order.STATUS = status;
db.SaveChanges();
return(true);
}
return(false);
}
// delete
public bool Delete(int id)
{
try
{
var t = db.LOAITINTUCs.Find(id);
db.LOAITINTUCs.Remove(t);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool ChangeStatus(decimal id)
{
var user = db.SANPHAMs.Find(id);
user.TRANGTHAI = !user.TRANGTHAI;
db.SaveChanges();
return(user.TRANGTHAI);
}
//lưu dữ liệu
public int SaveData(BannerModel x, string user)
{
try
{
if (x.BANNER_ID > 0)
{
BANNER dao = db.BANNERs.SingleOrDefault(m => m.BANNER_ID == x.BANNER_ID);
dao.HINH = x.HINH;
dao.IS_DELETE = false;
dao.MODIFILEDDATE = DateTime.Now.Date;
dao.MODIFILEDBY = user;
dao.LINK = x.LINK;
dao.GHICHU_BANNER = x.GHICHU_BANNER;
dao.CREATEBY = user;
dao.TIEUDE = x.TIEUDE;
dao.VITRI = x.VITRI;
db.SaveChanges();
return(1);
}
else
{
BANNER dao = new BANNER();
dao.HINH = x.HINH;
dao.IS_DELETE = false;
dao.MODIFILEDDATE = DateTime.Now.Date;
dao.MODIFILEDBY = user;
dao.CREATEBY = x.CREATEBY;
dao.TIEUDE = x.TIEUDE;
dao.VITRI = x.VITRI;
dao.LINK = x.LINK;
dao.GHICHU_BANNER = x.GHICHU_BANNER;
dao.CREATEDATE = DateTime.Now.Date;
dao.CREATEBY = user;
db.BANNERs.Add(dao);
db.SaveChanges();
return(2);
}
}
catch
{
return(0);
}
}
public int ChangeStatus(int id, string name, int stt)
{
try
{
var kq = db.ORDERs.Find(id);
kq.STATUS = stt;
db.SaveChanges();
return(stt);
}
catch (Exception ex)
{
return(0);
}
}
public int InsertFeedBack(FEEDBACK fb)
{
db.FEEDBACKs.Add(fb);
db.SaveChanges();
return(fb.ID);
}
public bool Delete(string id)
{
try
{
if (Commom.ComonConstants.MOD_GROUP == id || Commom.ComonConstants.ADMIN_GROUP == id)
{
return(false);
}
var t = db.LOAITAIKHOANs.Find(id);
t.IS_DELETE = true;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Insert(ORDERDETAIL detail)
{
try {
db.ORDERDETAILs.Add(detail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public decimal Insert(TinTucModel x)
{
try
{
TINTUC dao = new TINTUC();
dao.IS_DELETE = false;
dao.IDTAIKHOAN = x.IDTAIKHOAN;
dao.TIEUDE_TINTUC = x.TIEUDE_TINTUC;
dao.GHICHU_TINTUC = x.GHICHU_TINTUC;
dao.HINHANH_TINTUC = x.HINHANH_TINTUC;
dao.MOTA_TINTUC = x.MOTA_TINTUC;
dao.NOIDUNG = x.NOIDUNG;
dao.CREATEDATE = x.CREATEDATE;
dao.CREATEBY = x.CREATEBY;
db.TINTUCs.Add(dao);
db.SaveChanges();
return(dao.TINTUC_ID);
}
catch
{
return(-1);
}
}
public decimal Insert(TAIKHOAN tk)
{
db.TAIKHOANs.Add(tk);
db.SaveChanges();
return(tk.ID);
}
public decimal InsertNCC(NHACUNGCAP ncc)
{
db.NHACUNGCAPs.Add(ncc);
db.SaveChanges();
return(ncc.ID_NCC);
}
