public static bool put_CAT_Site(AppEntities db, int ID, DTO_CAT_Site item, string Username) { bool result = false; var dbitem = db.tbl_CAT_Site.Find(ID); if (dbitem != null) { dbitem.Code = item.Code; dbitem.Name = item.Name; dbitem.GhiChu = item.GhiChu; dbitem.Sort = item.Sort; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_Site", DateTime.Now, Username); result = true; } catch (DbEntityValidationException e) { errorLog.logMessage("put_CAT_Site", e); result = false; } } return(result); }
public IHttpActionResult Get(int id) { DTO_CAT_Site tbl_CAT_Site = BS_CAT_Site.get_CAT_Site(db, id); if (tbl_CAT_Site == null) { return(NotFound()); } return(Ok(tbl_CAT_Site)); }
public IHttpActionResult Post(DTO_CAT_Site tbl_CAT_Site) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DTO_CAT_Site result = BS_CAT_Site.post_CAT_Site(db, tbl_CAT_Site, Username); if (result != null) { return(CreatedAtRoute("get_CAT_Site", new { id = result.ID }, result)); } return(Conflict()); }
public static DTO_CAT_Site post_CAT_Site(AppEntities db, DTO_CAT_Site item, string Username) { tbl_CAT_Site dbitem = new tbl_CAT_Site(); if (item != null) { dbitem.Code = item.Code; dbitem.Name = item.Name; dbitem.GhiChu = item.GhiChu; dbitem.Sort = item.Sort; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.tbl_CAT_Site.Add(dbitem); db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_Site", DateTime.Now, Username); item.ID = dbitem.ID; item.CreatedBy = dbitem.CreatedBy; item.CreatedDate = dbitem.CreatedDate; item.ModifiedBy = dbitem.ModifiedBy; item.ModifiedDate = dbitem.ModifiedDate; } catch (DbEntityValidationException e) { errorLog.logMessage("post_CAT_Site", e); item = null; } } return(item); }
public IHttpActionResult Put(int id, DTO_CAT_Site tbl_CAT_Site) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_CAT_Site.ID) { return(BadRequest()); } bool result = BS_CAT_Site.put_CAT_Site(db, id, tbl_CAT_Site, Username); if (result) { return(StatusCode(HttpStatusCode.NoContent)); } else { return(NotFound()); } }