public long Create(tbl_Notification notification)
{
notification.dNgayTB = DateTime.Now;
db.tbl_Notification.Add(notification);
db.SaveChanges();
return(notification.ID);
}
public IHttpActionResult Puttbl_GioiThieu(long id, tbl_GioiThieu tbl_GioiThieu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_GioiThieu.IDGioiThieu)
{
return(BadRequest());
}
db.Entry(tbl_GioiThieu).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_GioiThieuExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public long Create(tbl_NCC ncc)
{
ncc.dNgayTao = DateTime.Now;
db.tbl_NCC.Add(ncc);
db.SaveChanges();
//tags
//lay danh sach tag
return(ncc.IDncc);
}
public long Create(tbl_BaiViet content)
{
if (string.IsNullOrEmpty(content.sTenTieuDecMeta))
{
content.sTenTieuDecMeta = StringHelper.ToUnsignString(content.sTieuDe);
}
//content.sImages = "http://192.168.0.107:7500" + content.sImages;
content.dNgayTao = DateTime.Now;
content.iViewCount = 0;
db.tbl_BaiViet.Add(content);
db.SaveChanges();
//tags
//lay danh sach tag
if (!string.IsNullOrEmpty(content.sTags))
{
string[] tags = content.sTags.Split(',');
foreach (var tag in tags)
{
var tagID = StringHelper.ToUnsignString(tag);
var existTag = this.CheckTag(tagID);
//them vao bang tag
if (!existTag)
{
this.InsertTag(tagID, tag);
}
//them vao bang tagBaiviet
this.InsertContentTag(content.IDBaiViet, tagID);
}
}
return(content.IDBaiViet);
}
public bool Insert(tbl_ChiTietHoaDon detail)
{
try
{
db.tbl_ChiTietHoaDon.Add(detail);
db.SaveChanges();
return(true);
}catch
{
return(false);
}
}
public long Insert(tbl_TaiKhoan entity)
{
db.tbl_TaiKhoan.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public bool Update(tbl_ChuDe entity)
{
try
{
var chude = db.tbl_ChuDe.Find(entity.IDChuDe);
chude.sTenChuDe = entity.sTenChuDe;
if (string.IsNullOrEmpty(chude.sTenChuDeMeta))
{
chude.sTenChuDeMeta = StringHelper.ToUnsignString(entity.sTenChuDe);
}
chude.sImage = entity.sImage;
chude.bStatus = entity.bStatus;
chude.dNgaySua = DateTime.Now;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(tbl_DanhMucSanPham entity)
{
try
{
var danhMucSanPham = db.tbl_DanhMucSanPham.Find(entity.IDDanhMuc);
danhMucSanPham.sTenDanhMuc = entity.sTenDanhMuc;
if (string.IsNullOrEmpty(danhMucSanPham.sTenDanhMucMeta))
{
danhMucSanPham.sTenDanhMucMeta = StringHelper.ToUnsignString(entity.sTenDanhMuc);
}
danhMucSanPham.sHinhAnhDanhMuc = entity.sHinhAnhDanhMuc;
danhMucSanPham.bStatus = entity.bStatus;
danhMucSanPham.dNgaySua = DateTime.Now;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool divSanPham(long id, int soluong)
{
try
{
var sanpham = db.tbl_SanPham.Find(id);
if (sanpham.iSoLuong >= soluong)
{
sanpham.iSoLuong = sanpham.iSoLuong - soluong;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public long InsertFeedBack(tbl_Feedback fb)
{
db.tbl_Feedback.Add(fb);
db.SaveChanges();
return fb.ID;
}
public long InsertCMT(tbl_SanPhamComment cmt)
{
db.tbl_SanPhamComment.Add(cmt);
db.SaveChanges();
return(cmt.IDComment);
}
public long Insert(tbl_PhieuYeuCauNhap phieuyeucau)
{
db.tbl_PhieuYeuCauNhap.Add(phieuyeucau);
db.SaveChanges();
return(phieuyeucau.IDPhieuYeuCau);
}
public long Insert(tbl_HoaDon order)
{
db.tbl_HoaDon.Add(order);
db.SaveChanges();
return(order.ID);
}
