public ActionResult EditFeature() { CommonDataService cds = new CommonDataService(); CommonModel cm = new CommonModel(); cm = cds.GenerateCommonModel(); Session["FaceBook"] = cm.FaceBook; Session["Twitter"] = cm.Twitter; Session["Youtube"] = cm.Youtube; Session["Instagram"] = cm.Instagram; Session["PhoneNumber"] = cm.PhoneNumber; Session["Email"] = cm.Email; Session["ShoppingHours"] = cm.ShoppingHours; FeatureHomeDataService fhDS = new FeatureHomeDataService(); FeatureMainModel fmv = new FeatureMainModel(); DataSet ds = new DataSet(); try { string featureId = (string)Request.QueryString["featureId"]; ds = fhDS.GetFeatureHomePageFeatureId(int.Parse(featureId)); if (ds != null) { if (ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { fmv = new FeatureMainModel(); fmv.FeatureId = Convert.ToInt32(ds.Tables[0].Rows[0]["FeatureId"]); fmv.FeatureImageURLString = Convert.ToString(ds.Tables[0].Rows[0]["FeatureImageURLString"]); fmv.FeatureDescription = Convert.ToString(ds.Tables[0].Rows[0]["FeatureDescription"]); } } } return(View(fmv)); } catch (Exception ex) { throw ex; } finally { fmv = null; ds = null; fhDS = null; } }
public void UpdateFeatureHomePage(FeatureMainModel fmv) { try { Database db = GetFactoryProvider(); DbCommand dbcomm = db.GetStoredProcCommand("UpdateFeautreHomePageByFeatureId"); db.AddInParameter(dbcomm, "@FeatureId", DbType.Int32, fmv.@FeatureId); db.AddInParameter(dbcomm, "@FeatureImageURLString", DbType.String, fmv.FeatureImageURLString); db.AddInParameter(dbcomm, "@FeatureDescription", DbType.String, fmv.FeatureDescription); db.ExecuteNonQuery(dbcomm); } catch (Exception ex) { throw ex; } }
public List <FeatureMainModel> GenerateFeatureMainModel() { try { FeatureHomeDataService dataService = new FeatureHomeDataService(); DataSet ds = new DataSet(); List <FeatureMainModel> viewModels = new List <FeatureMainModel>(); FeatureMainModel viewModel = new FeatureMainModel(); ds = dataService.GetFeatureHomePage(); if (ds != null) { if (ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { viewModel = new FeatureMainModel(); viewModel.FeatureId = Convert.ToInt32(ds.Tables[0].Rows[i]["FeatureId"]); viewModel.FeatureImageURLString = Convert.ToString(ds.Tables[0].Rows[i]["FeatureImageURLString"]); viewModel.FeatureDescription = Convert.ToString(ds.Tables[0].Rows[i]["FeatureDescription"]); viewModels.Add(viewModel); } } } } return(viewModels); } catch (Exception ex) { throw ex; } }
public ActionResult EditFeature(FeatureMainModel fmv) { CommonDataService cds = new CommonDataService(); CommonModel cm = new CommonModel(); cm = cds.GenerateCommonModel(); Session["FaceBook"] = cm.FaceBook; Session["Twitter"] = cm.Twitter; Session["Youtube"] = cm.Youtube; Session["Instagram"] = cm.Instagram; Session["PhoneNumber"] = cm.PhoneNumber; Session["Email"] = cm.Email; Session["ShoppingHours"] = cm.ShoppingHours; FeatureHomeDataService fhDS = new FeatureHomeDataService(); string featureId = (string)Request.Form["edit_FeatureId"]; string imageString = (string)Request.Form["edit_FeatureImageURLString"]; string featureDescription = (string)Request.Form["edit_featureDescription"]; try { if (ModelState.IsValid) { WebImage photo = null; var newFileName = ""; var imagePath = ""; photo = WebImage.GetImageFromRequest(); if (photo != null) { newFileName = Guid.NewGuid().ToString() + "_" + Path.GetFileName(photo.FileName); imagePath = @"Contents\Images\Home\" + newFileName; photo.Save(@"~\" + imagePath); fmv.FeatureId = int.Parse(featureId); fmv.FeatureImageURLString = imagePath; } else { fmv.FeatureId = int.Parse(featureId); fmv.FeatureImageURLString = imageString; } fhDS.UpdateFeatureHomePage(fmv); return(RedirectToAction("Edit", "Home")); } else { fmv = new FeatureMainModel(); fmv.FeatureId = int.Parse(featureId); fmv.FeatureDescription = featureDescription; fmv.FeatureImageURLString = imageString; return(View(fmv)); } } catch (Exception ex) { throw ex; } finally { fhDS = null; } }