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