public ActionResult Index() { IVendorService svc = new VendorService(); var model = svc.GetAll(); return(View("~/Views/Master/Vendor/Index.cshtml", model)); }
public FileResult Download() { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Vendor"); IVendorService svc = new VendorService(); var model = svc.GetAll(); xlWorkSheet.Cell(1, 1).Value = "VENDORID"; xlWorkSheet.Cell(1, 2).Value = "VENDORNAME"; xlWorkSheet.Cell(1, 3).Value = "STREET"; xlWorkSheet.Cell(1, 4).Value = "DISTRIC"; xlWorkSheet.Cell(1, 5).Value = "CITY"; xlWorkSheet.Cell(1, 6).Value = "POSTALCODE"; xlWorkSheet.Cell(1, 7).Value = "TELEPHONE"; xlWorkSheet.Cell(1, 8).Value = "EMAIL"; xlWorkSheet.Cell(1, 9).Value = "EMAIL2"; xlWorkSheet.Cell(1, 10).Value = "EMAIL3"; xlWorkSheet.Cell(1, 11).Value = "EMAIL4"; xlWorkSheet.Cell(1, 12).Value = "EMAIL5"; xlWorkSheet.Cell(1, 13).Value = "EMAIL6"; xlWorkSheet.Cell(1, 14).Value = "EMAIL7"; xlWorkSheet.Cell(1, 15).Value = "EMAIL8"; xlWorkSheet.Cell(1, 16).Value = "PLANTIDTSO"; xlWorkSheet.Cell(1, 16).Value = "ISB2B"; xlWorkSheet.Range("A1", "Q1").Style.Font.Bold = true; int i = 2; foreach (var m in model) { xlWorkSheet.Cell(i, 1).Value = "'" + m.VENDORID; xlWorkSheet.Cell(i, 2).Value = m.VENDORNAME; xlWorkSheet.Cell(i, 3).Value = m.STREET; xlWorkSheet.Cell(i, 4).Value = m.DISTRIC; xlWorkSheet.Cell(i, 5).Value = m.CITY; xlWorkSheet.Cell(i, 6).Value = m.POSTALCODE; xlWorkSheet.Cell(i, 7).Value = m.TELEPHONE; xlWorkSheet.Cell(i, 8).Value = m.EMAIL; xlWorkSheet.Cell(i, 9).Value = m.EMAIL2; xlWorkSheet.Cell(i, 10).Value = m.EMAIL3; xlWorkSheet.Cell(i, 11).Value = m.EMAIL4; xlWorkSheet.Cell(i, 12).Value = m.EMAIL5; xlWorkSheet.Cell(i, 13).Value = m.EMAIL6; xlWorkSheet.Cell(i, 14).Value = m.EMAIL7; xlWorkSheet.Cell(i, 15).Value = m.EMAIL8; xlWorkSheet.Cell(i, 16).Value = m.PLANTIDTSO; xlWorkSheet.Cell(i, 16).Value = m.B2B == '1' ? "1" : "0"; i++; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Vendor.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Vendor.xlsx")); }
public IEnumerable <VendorViewModel> GetAll() { //Log.Information("Log: Log.Information"); //Log.Warning("Log: Log.Warning"); //Log.Error("Log: Log.Error"); //Log.Fatal("Log: Log.Fatal"); var items = _vendorService.GetAll(); return(items); }
public virtual ActionResult List() { var result = new List <object>(); result.AddRange(SiteTermService.GetAll().IsActive().Cast <object>()); result.AddRange(ProductService.GetAll().IsActive().Cast <object>()); result.AddRange(ProfessionService.GetAll().IsActive().Cast <object>()); result.AddRange(VendorService.GetAll().IsActive().Cast <object>()); return(View(result.OrderBy(o => o.GetValue("Name")))); }
public void AddControlForTestingCenter(SimplePageVM model) { var vendors = VendorService.GetAll(x => Vendor.ForTest.Contains(x.Vendor_ID) && x.IsActive).ToList() .OrderBy(x => Vendor.ForTest.IndexOf(x.Vendor_ID)).ToList(); model.Controls.Add( new SimplePageVM.Control(Views.Shared.Catalog.Vendors, vendors) { OnBottom = true }); }
public ActionResult Create(long?id) { PaymentViewModel viewModel = new PaymentViewModel { vendors = vendorService.GetAll(), Accounts = accountService.GetAll(), Categories = categoryService.GetAll(), Bills = billService.GetAll(), Id = id ?? 0 }; return(View(viewModel)); }
public virtual ActionResult Details(string urlName, string urlPart, int?pageIndex) { VendorVM model; if (urlPart.IsEmpty()) { model = VendorVMService.GetBy(urlName, null); if (model == null) { return(null); } } else if (urlPart == VendorVM.Tab.Testing) { if (!pageIndex.HasValue) { return(RedirectToAction(() => Details(urlName, urlPart, 1))); } var vendor = VendorService.GetAll().ByUrlName(urlName); if (vendor == null) { return(NotFound()); } var exams = new ExamListVM { Exams = ExamService.GetAll().Where(e => e.ExamPrice > 0 && e.Available) .Where(e => e.Vendor_ID == vendor.Vendor_ID) .OrderBy(e => e.Exam_TC) .ToPagedList(pageIndex.GetValueOrDefault() - 1), Vendor = vendor }; model = new VendorVM(vendor) { CurrentTab = 2, Exams = exams }; } else { var vendor = VendorService.GetAll().ByUrlName(urlName); if (vendor == null) { return(null); } model = new VendorVM(vendor) { CurrentTab = 1 }; } return(View(model)); }
public ActionResult Create(long?id) { var viewModel = new BillViewModel { Categories = categoryService.GetAll(), Currencies = currencyService.GetAll(), Vendors = vendorService.GetAll(), Items = itemService.GetAll(), Taxes = taxService.GetAll(), DefaultSetting = defaultService.GetByUserId(LogedInUser.Id), Bill = id > 0 ? billService.GetById((long)id) : new Bill { Number = billService.GenerateBillNumber() } }; return(View(viewModel)); }
public virtual MainPageVM Get() { var sections = SectionService.GetAll().IsActive().Where(s => s.ForMainPage) .ByWebOrder().ToList(); var professions = ProfessionService.GetAll().IsActive() .Where(p => p.ForMainPage).ToList() .OrderBy(x => StringUtils.IsBasicLetter(x.Name.First())).ThenBy(x => x.Name).ToList(); var vendors = VendorService.GetAll().IsActive() .Where(p => p.ForMainPage).ByWebOrder().ToList(); var products = ProductService.GetAll().IsActive() .Where(p => p.ForMainPage).ToList().OrderBy(x => x.Name).ToList(); var siteterms = SiteTermService.GetAll().IsActive() .Where(p => p.ForMainPage).ToList().OrderBy(x => x.Name).ToList(); VideoService.LoadWith(x => x.VideoCategory); var videos = VideoService.GetAll(x => x.CategoryId == VideoCategories.CoursePresentation) .OrderByDescending(x => x.UpdateDate).Take(3).ToList(); return (new MainPageVM { Professions = professions, Vendors = vendors, Sections = sections, Products = products, Banners = BannerService.GetBanner(CommonConst.SiteRoot + "/") .ShufflePriority(x => x.Priority), News = NewsService.GetAllForMain().ToList(), SiteTerms = siteterms, Videos = videos, Documents = CertTypeService .GetAll(c => CertTypes.ForMain.Contains(c.UrlName)).ToList(), About = SimplePageService.GetAll().BySysName(SimplePages.MainPage) }); }
public ActionResult AddPackage() { ViewBag.Vendors = _vendorService.GetAll(); ViewBag.Destinations = _destinationService.GetAll(); return(View()); }
public List <Vendor> GetAll() { return(_vendorService.GetAll().ToList()); }