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