public HttpResponseMessage UpdateProduct(Product product)
{
ResponseMessage <STP_ProductDetails_Result> objResponseData = new ResponseMessage <STP_ProductDetails_Result>();
try
{
DataTable tempProductImages = new DataTable();
DataColumn dc = new DataColumn("TempId", typeof(int)); //creating first column of datatable
tempProductImages.Columns.Add(dc);
dc = new DataColumn("ImageUrl", typeof(String)); //creating second column of datatable
tempProductImages.Columns.Add(dc);
int isSucceeded = objProductDAL.UpdateProduct(product, tempProductImages);
if (isSucceeded > 0)
{
STP_ProductDetails_Result updatedProduct = objProductDAL.GetProductDetails(product);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Product Has Been Updated Successfully.", updatedProduct, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Can't Update Product.", HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetProductById(int Id)
{
ResponseMessage <STP_ProductDetails_Result> objResponseData = new ResponseMessage <STP_ProductDetails_Result>();
try
{
Product product = new Product();
product.ProductId = Id;
STP_ProductDetails_Result productDetails = objProductDAL.GetProductDetails(product);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Product details", productDetails, HttpStatusCode.OK);
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
/// <summary>
/// 2018/12/18 Deepanjali Yadav
/// Get product category details.
/// </summary>
/// <returns>List<Category></returns>
public STP_ProductDetails_Result GetProductDetails(Product product)
{
try
{
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
var ProductId = new SqlParameter("@ProductId", product.ProductId);
STP_ProductDetails_Result productDetails = db.Database.SqlQuery <STP_ProductDetails_Result>("STP_ProductDetails @ProductId", ProductId).FirstOrDefault();
if (productDetails != null)
{
return(productDetails);
}
return(null);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
throw ex;
}
}
