//public static PRICE price;
public static PRODUCTS_DTO getProductsById(int id)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
return(ProductsCRUD.ReadById(ctx, id));
}
}
public IHttpActionResult addProduct(PRODUCTS_DTO product)
{
try
{
var id = ProductsCRUD.Create(product);
return(Ok(id));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult Delete(PRODUCTS_DTO product)
{
try
{
ProductsCRUD.Delete(product);
return(Ok());
}
catch (Exception)
{
return(InternalServerError());
}
}
public static PRICE GetProductPrice(PRODUCTS_TBL product)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
var productdetail = ProductsCRUD.ReadById(ctx, product.productId);
if (productdetail != null)
{
PRICE price = ctx.PRICEs.Where(u => u.productId == product.productId).FirstOrDefault();
return(price);
}
return(null);
}
}
public static CategoryDetails GetCategoryDetailsById(int id)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
var categoryDetails = new CategoryDetails();
var category = CategoryCRUD.GetCategoryById(ctx, id);
if (category != null)
{
categoryDetails.Id = category.categoriesId;
categoryDetails.Name = category.categoryName;
var productList = ProductsCRUD.GetProductByCategoryId(ctx, id);
foreach (var product in productList)
{
categoryDetails.ProductsList.Add(product);
}
return(categoryDetails);
}
return(null);
}
}
