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
});
}
}
