public IHttpActionResult addProduct(PRODUCTS_DTO product)
{
try
{
var id = ProductsCRUD.Create(product);
return(Ok(id));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public static PRODUCTS_TBL CastToTBL(PRODUCTS_DTO a)
{
return(new PRODUCTS_TBL
{
productId = a.productId,
description = a.description,
categoryId = a.categoryId,
//CATEGORIES_TBL = db.CATEGORIES_TBL.Where(S => S.categoriesId == a.categoryId).FirstOrDefault(),
imag = a.imag,
name = a.name
});
}
public IHttpActionResult Delete(PRODUCTS_DTO product)
{
try
{
ProductsCRUD.Delete(product);
return(Ok());
}
catch (Exception)
{
return(InternalServerError());
}
}
//create
public static int Create(PRODUCTS_DTO product)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
// ctx.PRODUCTS_TBL.Add(new PRODUCTS_TBL { name = product.name, description = product.description, categoryId = product.categoryId });
PRODUCTS_TBL newProduct = new PRODUCTS_TBL()
{
name = product.name,
description = product.description,
categoryId = product.categoryId,
imag = product.imag
};
ctx.PRODUCTS_TBL.Add(newProduct);
ctx.SaveChanges();
var lastProduct = ctx.PRODUCTS_TBL.LastOrDefault();
return(lastProduct.productId);
}
}
//delete
public static void Delete(PRODUCTS_DTO product)
{
ctx.PRODUCTS_TBL.Remove(ctx.PRODUCTS_TBL.FirstOrDefault(u => u.productId == product.productId));
ctx.SaveChanges();
}
