public COrnaments GetOrnaments(int id)
{
COrnaments cOrnaments = new COrnaments();
cOrnaments = _ornamentsService.OrnamentsDetailGetById(id);
return(cOrnaments);
}
public COrnaments OrnamentsDetailGetById(int OrnamentsID)
{
COrnaments oResult = new COrnaments();
try
{
// SELECT THE INFORMATION FROM THE STORE-PROCEDURE AND SET INFORMATION TO THE DATASET
DataSet dsOrnamentsInfo = _sqlService.GetDataSet("TOrnamentsInfo,TImages", "uspOrnamentsInfoGet " + OrnamentsID);
List <string> images = new List <string>();
using (DataTable dtOrnamentsInfo = dsOrnamentsInfo.Tables["TOrnamentsInfo"])
{
if (dtOrnamentsInfo.Rows.Count > 0 && OrnamentsID > 0)
{
int ornamentID = Convert.ToInt32(dtOrnamentsInfo.Rows[0]["OrnamentID"].ToString());
using (DataTable dtImagesInfo = dsOrnamentsInfo.Tables["TImages"])
{
if (dtImagesInfo.Rows.Count > 0)
{
for (int jRow = 0; jRow <= dtImagesInfo.Rows.Count - 1; jRow++)
{
int imgOrnamnetID = Convert.ToInt32(dtImagesInfo.Rows[jRow]["OrnamentID"].ToString());
if (ornamentID == imgOrnamnetID)
{
images.Add(_sqlService.ImagePathGet(dtImagesInfo.Rows[jRow]["ImgPath"].ToString(), 0, string.Empty));
}
}
}
}
oResult.OrnamentID = Convert.ToInt32(dtOrnamentsInfo.Rows[0]["OrnamentID"].ToString());
oResult.OrnamentPositionID = Convert.ToInt32(dtOrnamentsInfo.Rows[0]["PositionID"].ToString());
oResult.CategoryID = Convert.ToInt32(dtOrnamentsInfo.Rows[0]["CategoryID"].ToString());
oResult.Name = dtOrnamentsInfo.Rows[0]["Name"].ToString();
oResult.Description = dtOrnamentsInfo.Rows[0]["Description"].ToString();
oResult.OrnamentPositionName = dtOrnamentsInfo.Rows[0]["PositionName"].ToString();
oResult.Weight = dtOrnamentsInfo.Rows[0]["Weight"].ToString();
oResult.Cost = Convert.ToDecimal(dtOrnamentsInfo.Rows[0]["Cost"].ToString());
oResult.OrnamentsImgPath = images;
oResult.Success = true;
oResult.WasSuccessful = 1;
}
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);
}
}
public OrnamentsModel(COrnaments oOrnaments)
{
OrnamentID = oOrnaments.OrnamentID;
Name = oOrnaments.Name;
Description = oOrnaments.Description;
CategoryID = oOrnaments.CategoryID;
CategoryName = oOrnaments.CategoryName;
OrnamentPositionID = oOrnaments.OrnamentPositionID;
OrnamentPositionName = oOrnaments.OrnamentPositionName;
Weight = oOrnaments.Weight;
Cost = oOrnaments.Cost;
}
public ActionResult Edit(int id)
{
try
{
// USED IN POST METHOD
ViewBag.IsSuccess = 0;
ViewBag.Message = "";
fnSetProperties();
COrnaments ornaments = CFOrnaments.OrnamentsDetailGetById(id);
OrnamentsModel objOrnamentsModel = new OrnamentsModel(ornaments);
return(View(objOrnamentsModel));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Error", new { Message = ex.Message, InnerException = ex.InnerException }));
}
}
