public async Task <BaseModel> Insert(Ref_StockWiseImagesModel stockWiseImage) { Ref_StockWiseImages stockWiseImageToDB = new Ref_StockWiseImages(); stockWiseImageToDB.imageID = stockWiseImage.imageID; stockWiseImageToDB.stockID = stockWiseImage.stockID; stockWiseImageToDB.title = stockWiseImage.title; stockWiseImageToDB.imageURL = stockWiseImage.imageURL; stockWiseImageToDB.userID = stockWiseImage.userID; try { string convertedImageData = stockWiseImage.imageData.Substring(stockWiseImage.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 + "\\Stock\\" + stockWiseImage.stockCode + "\\", "*", SearchOption.AllDirectories).Length; string filePath = imagePath + "\\Stock\\" + stockWiseImage.stockCode + "\\Stock_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); } stockWiseImageToDB.imageURL = filePath; using (var connection = new SqlConnection(_sCConnectionString)) { DynamicParameters para = new DynamicParameters(); string JsonData = JsonConvert.SerializeObject(stockWiseImageToDB); para.Add("@JsonData", JsonData, DbType.String); para.Add("@Action", "I", DbType.String); await connection.ExecuteAsync("[dbo].[TAG_AD_POPULATE_StocksWiseImages]", para, commandType : System.Data.CommandType.StoredProcedure); return(new BaseModel() { code = "1000", description = "Success", data = stockWiseImageToDB }); } } catch (Exception ex) { return(new BaseModel() { code = "998", description = ex.Message, data = stockWiseImageToDB }); } }
public async Task <BaseModel> Update(UpdateData data) { Ref_StockWiseImagesModel stockWiseImage = data.NewData.ToObject <Ref_StockWiseImagesModel>(); Ref_StockWiseImages stockWiseImageToDB = new Ref_StockWiseImages(); stockWiseImageToDB.imageID = stockWiseImage.imageID; stockWiseImageToDB.stockID = stockWiseImage.stockID; stockWiseImageToDB.title = stockWiseImage.title; stockWiseImageToDB.description = stockWiseImage.description; stockWiseImageToDB.imageURL = stockWiseImage.imageURL; stockWiseImageToDB.colorCode = stockWiseImage.colorCode; stockWiseImageToDB.userID = stockWiseImage.userID; try { string convertedImageData = stockWiseImage.imageData.Substring(stockWiseImage.imageData.LastIndexOf(',') + 1); byte[] image64 = Convert.FromBase64String(convertedImageData); //SettingsService settings = new SettingsService(_adminConnectionString, _sCConnectionString); //string imagePath = settings.SelectWithinProject("IMGP").Value; string filePath = stockWiseImage.imageURL; if (File.Exists(filePath)) { File.Delete(filePath); File.WriteAllBytes(filePath, image64); } else { Directory.CreateDirectory(Path.GetDirectoryName(filePath)); File.WriteAllBytes(filePath, image64); } stockWiseImageToDB.imageURL = filePath; using (var connection = new SqlConnection(_sCConnectionString)) { DynamicParameters para = new DynamicParameters(); string JsonData = JsonConvert.SerializeObject(stockWiseImageToDB); string OldJsonData = JsonConvert.SerializeObject(data.OldData); para.Add("@JsonData", JsonData, DbType.String); para.Add("@OldJsonData", OldJsonData, DbType.String); para.Add("@Action", "U", DbType.String); await connection.ExecuteAsync("[dbo].[TAG_AD_POPULATE_StocksWiseImages]", para, commandType : System.Data.CommandType.StoredProcedure); return(new BaseModel() { code = "1000", description = "Success", data = stockWiseImageToDB }); } } catch (Exception ex) { return(new BaseModel() { code = "998", description = ex.Message, data = stockWiseImageToDB }); } }
public async Task <ActionResult> Delete(Ref_StockWiseImagesModel data) { var response = await _service.Delete(data); return(Ok(response)); }