public async Task <BaseModel> Insert(Ref_StockModel stock) { Ref_Stock stockToDB = new Ref_Stock(); stockToDB.stockID = stock.stockID; stockToDB.code = stock.code; stockToDB.title = stock.title; stockToDB.description = stock.description; stockToDB.mainImageURL = stock.mainImageURL; stockToDB.colorCode = stock.colorCode; stockToDB.userID = stock.userID; try { string convertedImageData = stock.imageData.Substring(stock.imageData.LastIndexOf(',') + 1); byte[] image64 = Convert.FromBase64String(convertedImageData); SettingsService settings = new SettingsService(_adminConnectionString, _sCConnectionString); string imagePath = settings.SelectWithinProject("IMGP").Value; string filePath = imagePath + "\\Stock\\" + stockToDB.code + "\\Main.jpg"; if (File.Exists(filePath)) { File.Delete(filePath); File.WriteAllBytes(filePath, image64); } else { Directory.CreateDirectory(Path.GetDirectoryName(filePath)); File.WriteAllBytes(filePath, image64); } stockToDB.mainImageURL = filePath; using (var connection = new SqlConnection(_sCConnectionString)) { DynamicParameters para = new DynamicParameters(); string JsonData = JsonConvert.SerializeObject(stockToDB); para.Add("@JsonData", JsonData, DbType.String); para.Add("@Action", "I", DbType.String); await connection.ExecuteAsync("[dbo].[TAG_AD_POPULATE_Stocks]", para, commandType : System.Data.CommandType.StoredProcedure); return(new BaseModel() { code = "1000", description = "Success", data = stockToDB }); } } catch (Exception ex) { return(new BaseModel() { code = "998", description = ex.Message, data = stockToDB }); } }
public async Task <ActionResult> Delete(Ref_StockModel data) { var response = await _service.Delete(data); return(Ok(response)); }