public GalleryModel GetGalleryById(int id) { GalleryModel model = new GalleryModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Galleries.ToList() where p.GalleryId == id orderby p.GalleryId ascending select p; model = new GalleryModel(); model.GalleryId = tableList.FirstOrDefault().GalleryId; model.GalleryDescription = tableList.FirstOrDefault().GalleryDescription; model.GalleryTitle = tableList.FirstOrDefault().GalleryTitle; model.ImageString = tableList.FirstOrDefault().ImageString; return model; } } catch (Exception ex) { throw ex; } }
public List<GalleryModel> GenerateGalleryByRow(int row) { List<GalleryModel> modelList = new List<GalleryModel>(); GalleryModel model = new GalleryModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Galleries.ToList() where p.Row == row orderby p.GalleryId ascending select p; foreach (var item in tableList) { model = new GalleryModel(); model.GalleryId = item.GalleryId; model.GalleryDescription = item.GalleryDescription; model.GalleryTitle = item.GalleryTitle; model.Row = item.Row; model.ImageString = item.ImageString; modelList.Add(model); } return modelList; } } catch (Exception ex) { throw ex; } }
public AddressModel GenerateAddressModel() { try { AddressModel model = new AddressModel(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { var table = from p in vdc.Addresses.ToList() select p; model = new AddressModel(); model.AddressId = table.FirstOrDefault().AddressId; model.AddressLine1 = table.FirstOrDefault().AddressLine1; model.AddressLine2 = table.FirstOrDefault().AddressLine2; model.Country = table.FirstOrDefault().Country; model.PostCode = table.FirstOrDefault().PostCode; return model; } } catch (Exception ex) { throw ex; } }
public void DeleteGallery(int galleryId) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var remove = (from aremove in vdc.Galleries where aremove.GalleryId == galleryId select aremove).FirstOrDefault(); if (remove != null) { vdc.Galleries.DeleteOnSubmit(remove); vdc.SubmitChanges(); } } } catch (Exception ex) { throw ex; } }
public List<PartnersModel> GeneratePartnerModel() { try { List<PartnersModel> pmList = new List<PartnersModel>(); PartnersModel pm = new PartnersModel(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { var partner = from p in vdc.Partners.ToList() orderby p.PartnerId ascending select p; foreach (var item in partner) { pm = new PartnersModel(); pm.PartnerId = item.PartnerId; pm.ImageUrl = item.ImageUrl; pm.Description = item.Description; pm.Sequence = item.Sequence; pmList.Add(pm); } return pmList; } } catch (Exception ex) { throw ex; } }
public List<ProductsListModel> GenerateProductsListModel() { List<ProductsListModel> plmList = new List<ProductsListModel>(); ProductsListModel plm = new ProductsListModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var productsList = from p in vdc.ProductsLists.ToList() orderby p.ProductId ascending select p; foreach (var item in productsList) { plm = new ProductsListModel(); plm.ProductsId = item.ProductId; plm.MainDescription = item.MainDescription; plm.DetailsDescription = item.DetailsDescription; plmList.Add(plm); } return plmList; } } catch (Exception ex) { throw ex; } }
public ContactModel GenerateContactModel() { try { ContactModel model = new ContactModel(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { var table = from p in vdc.Contacts.ToList() select p; model = new ContactModel(); model.CompanyName = table.FirstOrDefault().CompanyName; model.ContactId = table.FirstOrDefault().ContactId; return model; } } catch (Exception ex) { throw ex; } }
public ContactAdditionalModel GenerateContactAdditionalModelById(int id) { try { ContactAdditionalModel model = new ContactAdditionalModel(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { var table = from p in vdc.ContactAdditionals.ToList() where p.ContactAdditionalId == id select p; model = new ContactAdditionalModel(); model.ContactAdditionalId = table.FirstOrDefault().ContactAdditionalId; model.ContactTitle = table.FirstOrDefault().ContactTitle; model.ContactDescription = table.FirstOrDefault().ContactDescription; return model; } } catch (Exception ex) { throw ex; } }
public void DeleteHeader(int productLabelId) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var remove = (from aremove in vdc.ProductHeaders where aremove.ProductLabelId == productLabelId select aremove).FirstOrDefault(); if (remove != null) { vdc.ProductHeaders.DeleteOnSubmit(remove); vdc.SubmitChanges(); } } } catch (Exception ex) { throw ex; } }
public PromoModel GeneratePromoModel() { PromoModel model = new PromoModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Promos.ToList() orderby p.PromoId ascending select p; if (tableList != null) { if (tableList.FirstOrDefault() != null) { model = new PromoModel(); model.PromoId = tableList.FirstOrDefault().PromoId; model.PromoTitle = tableList.FirstOrDefault().PromoTitle; model.PromoDescription = tableList.FirstOrDefault().PromoDescription; model.ImageString = tableList.FirstOrDefault().ImageString; } } return model; } } catch (Exception ex) { throw ex; } }
public ProductsMainModel GenerateProductsMainModel() { ProductsMainModel pmm = new ProductsMainModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var productsMain = from p in vdc.ProductsMains.ToList() orderby p.ProductsMainId ascending select p; if (productsMain.FirstOrDefault() != null) { pmm = new ProductsMainModel(); pmm.ProductsMainId = productsMain.FirstOrDefault().ProductsMainId; pmm.ImageURLString = productsMain.FirstOrDefault().ImageURLString; pmm.ProductMainParagraph = productsMain.FirstOrDefault().ProductMainParagraph; pmm.ProductSubParagraph = productsMain.FirstOrDefault().ProductSubParagraph; pmm.ProductMainParagraphTitle = productsMain.FirstOrDefault().ProductMainParagraphTitle; pmm.ProductSubParagraphTitle = productsMain.FirstOrDefault().ProductSubParagraphTitle; } return pmm; } } catch (Exception ex) { throw ex; } }
public void UpdatePromo(PromoModel model) { try { Promo table = new Promo(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.Promos.Single(a => a.PromoId == model.PromoId); table.PromoId = model.PromoId; table.PromoTitle = model.PromoTitle; table.PromoDescription = model.PromoDescription; table.ImageString = model.ImageString; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public AboutUsModel GenerateAboutUsModel() { AboutUsModel aum = new AboutUsModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var aboutus = from about in vdc.AboutUs.ToList() orderby about.AboutUsId ascending select about; aum = new AboutUsModel(); aum.AboutUsId = aboutus.FirstOrDefault().AboutUsId; aum.AboutUsParagraph = aboutus.FirstOrDefault().AboutUsParagraph; aum.AboutUsTitle = aboutus.FirstOrDefault().AboutUsTitle; aum.ImageUrl = aboutus.FirstOrDefault().ImageUrl; return aum; } } catch (Exception ex) { throw ex; } }
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 InsertProductCategory(ProductCategoryModel pcm) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { ProductCategory receivedPM = new ProductCategory(); receivedPM.ProductCategory1 = pcm.ProductCategory; vdc.ProductCategories.InsertOnSubmit(receivedPM); vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void InsertPriceList(PriceListModel model) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { PriceList table = new PriceList(); table.ProductCategoryId = model.ProductCategoryId; table.ProductName = model.ProductName; table.ProductDescription = model.ProductDescription; table.Price = model.Price; vdc.PriceLists.InsertOnSubmit(table); 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 void UpdateShoppingHours(int id, string description) { try { ShoppingHour table = new ShoppingHour(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.ShoppingHours.Single(a => a.ShoppingHoursId == id); table.ShoppingHours = description; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void UpdateSocialMedia(int id, string description) { try { SocialMedia table = new SocialMedia(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.SocialMedias.Single(a => a.SocialMediaId == id); table.SocialMediaUrl = description; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void UpdatePriceList(PriceListModel model) { try { PriceList table = new PriceList(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.PriceLists.Single(a => a.PriceListId == model.PriceListId); table.ProductDescription = model.ProductDescription; table.ProductName = model.ProductName; table.Price = model.Price; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public ContactNumbersModel GenerateContactNumbersModelById(int contactNumberId) { try { ContactNumbersModel model = new ContactNumbersModel(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { var table = from p in vdc.ContactNumbers.ToList() where p.ContactNumberId == contactNumberId select p; model = new ContactNumbersModel(); model.ContactNumber = table.FirstOrDefault().ContactNumber1; model.ContactNumberId = table.FirstOrDefault().ContactNumberId; return model; } } catch (Exception ex) { throw ex; } }
public void UpdateAboutUsImage(int aboutUsId, string imageUrl) { try { AboutUs au = new AboutUs(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { au = vdc.AboutUs.Single(a => a.AboutUsId == aboutUsId); au.ImageUrl = imageUrl; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void UpdateAboutUs(AboutUsModel aum) { try { AboutUs au = new AboutUs(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { au = vdc.AboutUs.Single(a => a.AboutUsId == aum.AboutUsId); au.AboutUsId = aum.AboutUsId; au.AboutUsParagraph = aum.AboutUsParagraph; au.AboutUsTitle = aum.AboutUsTitle; 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 void InsertPartner(string imageURL) { try { int sequence = 0; using (VenturadaDataContext vdc = new VenturadaDataContext()) { var partner = from p in vdc.Partners.ToList() orderby p.Sequence descending select p; if (partner.Count() > 0) { sequence = partner.First().Sequence + 1; } else { sequence = 1; } } using (VenturadaDataContext vdc = new VenturadaDataContext()) { Partner receivedPM = new Partner(); receivedPM.ImageUrl = imageURL; receivedPM.Sequence = sequence; vdc.Partners.InsertOnSubmit(receivedPM); vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void UpdateProductCategory(ProductCategoryModel pcm) { try { ProductCategory table = new ProductCategory(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.ProductCategories.Single(a => a.ProductCategoryId == pcm.ProductCategoryId); table.ProductCategoryId = pcm.ProductCategoryId; table.ProductCategory1 = pcm.ProductCategory; vdc.SubmitChanges(); } } 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 ProductCategoryModel GetProductCategoryModelByProductCategoryId(int productCategoryId) { ProductCategoryModel model = new ProductCategoryModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductCategories.ToList() where p.ProductCategoryId == productCategoryId select p; if (list != null) { model.ProductCategoryId = list.FirstOrDefault().ProductCategoryId; model.ProductCategory = list.FirstOrDefault().ProductCategory1; } return model; } } catch (Exception ex) { throw ex; } }
public void UpdateEmailAddress(int emailAddressId, string emailAddress) { try { EmailAddress table = new EmailAddress(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.EmailAddresses.Single(a => a.EmailAddressId == emailAddressId); table.EmailAddress1 = emailAddress; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }