public CImages GetCategoryImages()
{
// 1: Category, 2: Ornaments 3: Position
CImages oImages = new CImages();
oImages = _generalService.GetImages(3);
return(oImages);
}
public CImages GetImages(int type, int id = 0)
{
CImages oResult = new CImages();
try
{
// SELECT THE INFORMATION FROM THE STORE-PROCEDURE AND SET INFORMATION TO THE DATASET
// 1: Category, 2: Ornaments 3: Position
string spParameter = type + ", "
+ id;
DataSet dsImages = _sqlService.GetDataSet("TImages", "uspGetImages " + spParameter);
using (DataTable dtImages = dsImages.Tables["TImages"])
{
if (dtImages.Rows.Count > 0)
{
for (int iRow = 0; iRow <= dtImages.Rows.Count - 1; iRow++)
{
// SET THE DATASET INFORMATION TO THE RETURN VALUE
oResult.ImagesList.Add(_sqlService.ImagePathGet(dtImages.Rows[iRow]["ImgPath"].ToString(), 0, string.Empty));
}
}
else
{
oResult.Success = false;
oResult.WasSuccessful = 0;
oResult.Exception = "No Record Found!";
}
return(oResult);
}
}
catch (Exception ex)
{
oResult.Success = false;
oResult.WasSuccessful = 0;
oResult.Exception = ex.Message;
return(oResult);
}
}
