public async Task <BaseModel> Insert(Ref_RetailWiseImagesModel retailWiseImage) { Ref_RetailWiseImages retailWiseImageToDB = new Ref_RetailWiseImages(); retailWiseImageToDB.imageID = retailWiseImage.imageID; retailWiseImageToDB.retailID = retailWiseImage.retailID; retailWiseImageToDB.title = retailWiseImage.title; retailWiseImageToDB.imageURL = retailWiseImage.imageURL; retailWiseImageToDB.userID = retailWiseImage.userID; try { string convertedImageData = retailWiseImage.imageData.Substring(retailWiseImage.imageData.LastIndexOf(',') + 1); byte[] image64 = Convert.FromBase64String(convertedImageData); SettingsService settings = new SettingsService(_adminConnectionString, _sCConnectionString); string imagePath = settings.SelectWithinProject("IMGP").Value; int count = Directory.GetFiles(imagePath + "\\Retail\\" + retailWiseImage.retailCode + "\\", "*", SearchOption.AllDirectories).Length; string filePath = imagePath + "\\Retail\\" + retailWiseImage.retailCode + "\\Retail_Wise_Images" + (count + 1).ToString() + ".jpg"; if (File.Exists(filePath)) { File.Delete(filePath); File.WriteAllBytes(filePath, image64); } else { Directory.CreateDirectory(Path.GetDirectoryName(filePath)); File.WriteAllBytes(filePath, image64); } retailWiseImageToDB.imageURL = filePath; using (var connection = new SqlConnection(_sCConnectionString)) { DynamicParameters para = new DynamicParameters(); string JsonData = JsonConvert.SerializeObject(retailWiseImageToDB); para.Add("@JsonData", JsonData, DbType.String); para.Add("@Action", "I", DbType.String); await connection.ExecuteAsync("[dbo].[TAG_AD_POPULATE_RetailsWiseImages]", para, commandType : System.Data.CommandType.StoredProcedure); return(new BaseModel() { code = "1000", description = "Success", data = retailWiseImageToDB }); } } catch (Exception ex) { return(new BaseModel() { code = "998", description = ex.Message, data = retailWiseImageToDB }); } }
public async Task <BaseModel> Delete(Ref_RetailWiseImagesModel retailWiseImage) { Ref_RetailWiseImages retailWiseImageToDB = new Ref_RetailWiseImages(); retailWiseImageToDB.imageID = retailWiseImage.imageID; retailWiseImageToDB.retailID = retailWiseImage.retailID; retailWiseImageToDB.title = retailWiseImage.title; retailWiseImageToDB.description = retailWiseImage.description; retailWiseImageToDB.imageURL = retailWiseImage.imageURL; retailWiseImageToDB.colorCode = retailWiseImage.colorCode; retailWiseImageToDB.userID = retailWiseImage.userID; try { string convertedImageData = retailWiseImage.imageData.Substring(retailWiseImage.imageData.LastIndexOf(',') + 1); byte[] image64 = Convert.FromBase64String(convertedImageData); //SettingsService settings = new SettingsService(_adminConnectionString, _sCConnectionString); //string imagePath = settings.SelectWithinProject("IMGP").Value; string filePath = retailWiseImage.imageURL; //string filePath = imagePath + "\\Stock\\" + stockWiseImage.stockCode + "\\" + stockWiseImage.imageID.ToString() + ".jpg"; if (File.Exists(filePath)) { File.Delete(filePath); File.WriteAllBytes(filePath, image64); } retailWiseImageToDB.imageURL = filePath; using (var connection = new SqlConnection(_sCConnectionString)) { DynamicParameters para = new DynamicParameters(); string JsonData = JsonConvert.SerializeObject(retailWiseImageToDB); para.Add("@JsonData", JsonData, DbType.String); para.Add("@Action", "D", DbType.String); await connection.ExecuteAsync("[dbo].[TAG_AD_POPULATE_RetailsWiseImages]", para, commandType : System.Data.CommandType.StoredProcedure); return(new BaseModel() { code = "1000", description = "Success", data = retailWiseImageToDB }); } } catch (Exception ex) { return(new BaseModel() { code = "998", description = ex.Message, data = retailWiseImageToDB }); } }
public async Task <ActionResult> Delete(Ref_RetailWiseImagesModel data) { var response = await _service.Delete(data); return(Ok(response)); }