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