public async Task <IActionResult> Put(int id, [FromBody] TypeProductDTO value) { try { if (!ModelState.IsValid) { return(BadRequest()); } var entity = await _dbContext.TypeProducts.FirstOrDefaultAsync(c => c.Id == id); if (entity == null) { return(BadRequest()); } entity.Id = value.Id; entity.Description = value.Description; _dbContext.Update(entity); await _dbContext.SaveChangesAsync(); return(Ok()); } catch (System.Exception) { return(StatusCode((int)HttpStatusCode.InternalServerError, "Error Editar Tipo de Producto")); } }
public async Task <IActionResult> Post([FromBody] TypeProductDTO value) { try { if (!ModelState.IsValid) { return(BadRequest()); } var result = await _dbContext.AddAsync(new TypeProduct { Id = value.Id, Description = value.Description }); await _dbContext.SaveChangesAsync(); return(Ok()); } catch (System.Exception) { return(StatusCode((int)HttpStatusCode.InternalServerError, "Error Almacenando Tipo de Producto")); } }
public static bool InsertTypeProduct(TypeProductDTO tydr) { string query = "Exec InsertTypeProduct @nametype , @status "; if (DataProvider.Instance.ExcuteNonQuery(query, new object[] { tydr.NameType, tydr.Status }) == 1) { return(true); } return(false); }
public static bool DeleteTypeProduct(TypeProductDTO tydr) { string query = "Exec DeleteTypeProduct @id"; if (DataProvider.Instance.ExcuteNonQuery(query, new object[] { tydr.ID }) == 1) { return(true); } return(false); }
public static List <TypeProductDTO> GetListTypeProductWithStatusOne(int status) { List <TypeProductDTO> listtype = new List <TypeProductDTO>();// 0 ẩn , 1 hiện string query = "select * from TYPEPRODUCT where Status = " + status; DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { TypeProductDTO type = new TypeProductDTO(item); listtype.Add(type); } return(listtype); }
public static List <TypeProductDTO> GetAllListTypeProduct() { List <TypeProductDTO> listtypeProduct = new List <TypeProductDTO>(); string query = "select * from TYPEProduct"; DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { TypeProductDTO typeProduct = new TypeProductDTO(item); listtypeProduct.Add(typeProduct); } return(listtypeProduct); }
public static bool UpdateTypeProduct(TypeProductDTO tydr) => TypeProductDAO.UpdateTypeProduct(tydr);
public static bool InsertTypeProduct(TypeProductDTO tydr) => TypeProductDAO.InsertTypeProduct(tydr);
public static bool DeleteTypeProduct(TypeProductDTO tydr) => TypeProductDAO.DeleteTypeProduct(tydr);