M_ProductImage IProductDA.UploadProductImages(M_ProductImage image) { try { DataTable dt = new DataTable(); if (connString.State == ConnectionState.Closed) { connString.Open(); } cmd = new SqlCommand("uspUploadProductImages", connString); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProductImageId", image.ProductImageId); cmd.Parameters.AddWithValue("@ProductId", image.ProductId); cmd.Parameters.AddWithValue("@ProductImage", image.ProductImage); cmd.Parameters.AddWithValue("@CreatedBy", image.CreatedBy); cmd.Parameters.AddWithValue("@IsDefault", image.IsDefault); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); sda.Dispose(); M_ProductImage result = ExtensionMethods.ConvertToListOf <M_ProductImage>(dt).FirstOrDefault(); return(result); } catch (Exception ex) { return(null); } }
M_ProductImage IProduct.UploadProductImage(M_ProductImage image) { try { M_ProductImage proImg = iProduct.UploadProductImages(image); return(proImg); } catch (Exception ex) { return(null); } }
public async Task <HttpResponseMessage> UploadProductImages(M_ProductImage images) { try { M_ProductImage proImg = await Task.Run(() => iproduct.UploadProductImage(images)); if (proImg != null) { return(Request.CreateResponse(HttpStatusCode.OK, proImg)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, new { StatusCode = HttpStatusCode.BadRequest, Status = "Failed" })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }