public void InsertProductHeader(ProductHeaderModel model) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { ProductHeader table = new ProductHeader(); table.ProductTableTitleDescription = model.ProductTableTitleDescription; table.ProductCategoryId = model.ProductCategoryId; vdc.ProductHeaders.InsertOnSubmit(table); vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void UpdateHeader(ProductHeaderModel model) { try { ProductHeader table = new ProductHeader(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.ProductHeaders.Single(a => a.ProductLabelId == model.ProductLabelId); table.ProductTableTitleDescription = model.ProductTableTitleDescription; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public List<ProductHeaderModel> GetProductHeaderByProductCategoryId(int productCategoryId) { List<ProductHeaderModel> modelList = new List<ProductHeaderModel>(); ProductHeaderModel model = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductHeaders.ToList() where p.ProductCategoryId == productCategoryId orderby p.ProductLabelId ascending select p; foreach (var item in list) { model = new ProductHeaderModel(); model.ProductLabelId = item.ProductLabelId; model.ProductCategoryId = item.ProductCategoryId; model.ProductTableTitleDescription = item.ProductTableTitleDescription; modelList.Add(model); } return modelList; } } catch (Exception ex) { throw ex; } }
public ProductHeaderModel GetProductHeaderByHeaderId(int productLabelId) { ProductHeaderModel model = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductHeaders.ToList() where p.ProductLabelId == productLabelId select p; if (list != null) { model.ProductCategoryId = list.FirstOrDefault().ProductCategoryId; model.ProductLabelId = list.FirstOrDefault().ProductLabelId; model.ProductTableTitleDescription = list.FirstOrDefault().ProductTableTitleDescription; } return model; } } catch (Exception ex) { throw ex; } }
public List<ProductCategoryModel> GenerateProductCategoryModel() { List<ProductCategoryModel> modelList = new List<ProductCategoryModel>(); ProductCategoryModel model = new ProductCategoryModel(); ProductHeaderModel model2 = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductCategories.ToList() orderby p.ProductCategoryId ascending select p; foreach (var item in list) { model = new ProductCategoryModel(); model.ProductCategoryId = item.ProductCategoryId; model.ProductCategory = item.ProductCategory1; //model.ProductHeaderModel = GetProductHeaderByProductCategoryId(item.ProductCategoryId); model.PriceListModel = GetPriceListByProductCategoryId(item.ProductCategoryId); modelList.Add(model); } return modelList; } } catch (Exception ex) { throw ex; } }
public ActionResult AddHeader(string tableHeader, int productCategoryId) { 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; PriceDataService dataService = new PriceDataService(); ProductHeaderModel model = new ProductHeaderModel(); try { model.ProductCategoryId = productCategoryId; model.ProductTableTitleDescription = tableHeader; dataService.InsertProductHeader(model); return RedirectToAction("Edit", "Price"); } catch (Exception ex) { throw ex; } finally { dataService = null; } }
public ActionResult EditHeader(int headerId) { 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; PriceDataService dataService = new PriceDataService(); ProductHeaderModel model = new ProductHeaderModel(); try { model = dataService.GetProductHeaderByHeaderId(headerId); return View(model); } catch (Exception ex) { throw ex; } finally { dataService = null; } }