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 ActionResult Add() { 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; GalleryModel model = new GalleryModel(); return View(model); }
public ActionResult Add(GalleryModel model) { 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; GalleryDataService dataservice = new GalleryDataService(); string galleryId = (string)Request.Form["edit_GalleryId"]; string imageString = (string)Request.Form["edit_ImageString"]; string galleryTitle = (string)Request.Form["edit_GalleryTitle"]; string galleryDescription = (string)Request.Form["edit_GalleryDescription"]; 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\Gallery\" + newFileName; photo.Save(@"~\" + imagePath); //model.ServicesId = int.Parse(serviceId); model.ImageString = imagePath; } else { //model.ServicesId = int.Parse(serviceId); model.ImageString = imageString; } dataservice.InsertGallery(model); return RedirectToAction("Edit", "Gallery"); } else { //model.ServicesId = int.Parse(serviceId); model.ImageString = imageString; return View(model); } } catch (Exception ex) { throw ex; } finally { model = null; dataservice = null; } }
public ActionResult EditGallery(int galleryId) { 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; GalleryModel model = new GalleryModel(); GalleryDataService dataService = new GalleryDataService(); try { model = dataService.GetGalleryById(galleryId); return View(model); } catch (Exception ex) { throw ex; } finally { dataService = null; } }
public void UpdateGallery(GalleryModel model) { try { Gallery table = new Gallery(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.Galleries.Single(a => a.GalleryId == model.GalleryId); table.GalleryId = model.GalleryId; table.GalleryTitle = model.GalleryTitle; table.GalleryDescription = model.GalleryDescription; table.ImageString = model.ImageString; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void InsertGallery(GalleryModel model) { try { int row = 0; using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Galleries.ToList() where p.Row == 1 select p; if (tableList.ToList().Count <= 3) { row = 1; } var tableList2 = from p in vdc.Galleries.ToList() where p.Row == 2 select p; if (tableList2.ToList().Count <= 3 && tableList.ToList().Count == 3) { row = 2; } var tableList3 = from p in vdc.Galleries.ToList() where p.Row == 3 select p; if (tableList3.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3) { row = 3; } var tableList4 = from p in vdc.Galleries.ToList() where p.Row == 4 select p; if (tableList4.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3) { row = 4; } var tableList5 = from p in vdc.Galleries.ToList() where p.Row == 5 select p; if (tableList5.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3) { row = 5; } var tableList6 = from p in vdc.Galleries.ToList() where p.Row == 6 select p; if (tableList6.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3) { row = 6; } var tableList7 = from p in vdc.Galleries.ToList() where p.Row == 7 select p; if (tableList6.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3) { row = 7; } var tableList8 = from p in vdc.Galleries.ToList() where p.Row == 8 select p; if (tableList8.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3) { row = 8; } var tableList9 = from p in vdc.Galleries.ToList() where p.Row == 9 select p; if (tableList9.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3) { row = 9; } var tableList10 = from p in vdc.Galleries.ToList() where p.Row == 10 select p; if (tableList10.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3) { row = 10; } var tableList11 = from p in vdc.Galleries.ToList() where p.Row == 11 select p; if (tableList11.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3) { row = 11; } var tableList12 = from p in vdc.Galleries.ToList() where p.Row == 12 select p; if (tableList12.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3) { row = 12; } var tableList13 = from p in vdc.Galleries.ToList() where p.Row == 13 select p; if (tableList13.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3) { row = 13; } var tableList14 = from p in vdc.Galleries.ToList() where p.Row == 14 select p; if (tableList14.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3) { row = 14; } var tableList15 = from p in vdc.Galleries.ToList() where p.Row == 15 select p; if (tableList15.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3) { row = 15; } var tableList16 = from p in vdc.Galleries.ToList() where p.Row == 16 select p; if (tableList16.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3) { row = 16; } var tableList17 = from p in vdc.Galleries.ToList() where p.Row == 17 select p; if (tableList17.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3) { row = 17; } var tableList18 = from p in vdc.Galleries.ToList() where p.Row == 18 select p; if (tableList18.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3) { row = 18; } var tableList19 = from p in vdc.Galleries.ToList() where p.Row == 19 select p; if (tableList19.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3) { row = 19; } var tableList20 = from p in vdc.Galleries.ToList() where p.Row == 20 select p; if (tableList20.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3) { row = 20; } var tableList21 = from p in vdc.Galleries.ToList() where p.Row == 21 select p; if (tableList21.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3) { row = 21; } var tableList22 = from p in vdc.Galleries.ToList() where p.Row == 22 select p; if (tableList22.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3) { row = 22; } var tableList23 = from p in vdc.Galleries.ToList() where p.Row == 23 select p; if (tableList23.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3) { row = 23; } var tableList24 = from p in vdc.Galleries.ToList() where p.Row == 24 select p; if (tableList24.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3) { row = 24; } var tableList25 = from p in vdc.Galleries.ToList() where p.Row == 25 select p; if (tableList25.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3) { row = 25; } var tableList26 = from p in vdc.Galleries.ToList() where p.Row == 26 select p; if (tableList26.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3 && tableList25.ToList().Count == 3) { row = 26; } var tableList27 = from p in vdc.Galleries.ToList() where p.Row == 27 select p; if (tableList27.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3 && tableList25.ToList().Count == 3 && tableList26.ToList().Count == 3) { row = 27; } var tableList28 = from p in vdc.Galleries.ToList() where p.Row == 28 select p; if (tableList28.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3 && tableList25.ToList().Count == 3 && tableList26.ToList().Count == 3 && tableList27.ToList().Count == 3) { row = 28; } var tableList29 = from p in vdc.Galleries.ToList() where p.Row == 29 select p; if (tableList29.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3 && tableList25.ToList().Count == 3 && tableList26.ToList().Count == 3 && tableList27.ToList().Count == 3 && tableList28.ToList().Count == 3) { row = 29; } var tableList30 = from p in vdc.Galleries.ToList() where p.Row == 30 select p; if (tableList30.ToList().Count <= 3 && tableList.ToList().Count == 3 && tableList2.ToList().Count == 3 && tableList3.ToList().Count == 3 && tableList4.ToList().Count == 3 && tableList5.ToList().Count == 3 && tableList6.ToList().Count == 3 && tableList7.ToList().Count == 3 && tableList8.ToList().Count == 3 && tableList9.ToList().Count == 3 && tableList10.ToList().Count == 3 && tableList11.ToList().Count == 3 && tableList12.ToList().Count == 3 && tableList13.ToList().Count == 3 && tableList14.ToList().Count == 3 && tableList15.ToList().Count == 3 && tableList16.ToList().Count == 3 && tableList17.ToList().Count == 3 && tableList18.ToList().Count == 3 && tableList19.ToList().Count == 3 && tableList20.ToList().Count == 3 && tableList21.ToList().Count == 3 && tableList22.ToList().Count == 3 && tableList23.ToList().Count == 3 && tableList24.ToList().Count == 3 && tableList25.ToList().Count == 3 && tableList26.ToList().Count == 3 && tableList27.ToList().Count == 3 && tableList28.ToList().Count == 3 && tableList29.ToList().Count == 3) { row = 30; } } using (VenturadaDataContext vdc = new VenturadaDataContext()) { Gallery table = new Gallery(); table.GalleryTitle = model.GalleryTitle; table.GalleryDescription = model.GalleryDescription; table.ImageString = model.ImageString; table.Row = row; vdc.Galleries.InsertOnSubmit(table); vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }