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