Esempio n. 1
0
        public List <QuotationViewModel> GetDealerCompanyList(long From, long To, long DealerProductId, long DealerServiceId)
        {
            //List<long> cMS_DealerCities = CMSEntities.CMS_DealerCity.Where(x => x.CityId == From || x.CityId == To).Select(x => x.CityId).ToList();
            List <long> cMS_DealerCities = new List <long> {
                From, To
            };
            List <CMS_DealerInfo> dealers = (from d in CMSEntities.CMS_DealerInfo join c in CMSEntities.CMS_DealerCity on d.DealerId equals
                                             c.DealerId where cMS_DealerCities.Contains(c.CityId) join p in CMSEntities.CMS_DealerProductCategory
                                             on d.DealerId equals p.DealerId where p.CategoryId == DealerProductId join s in CMSEntities.CMS_DealerService
                                             on d.DealerId equals s.DealerId where s.ServiceId == DealerServiceId select d).Include(x => x.CMS_DealerRate).ToList();

            //List<decimal> perkgprice = dealers[0].CMS_DealerRate.Cast<CMS_DealerRate>().Select(x => x.PerKgPrice).ToList();

            //dealers = dealers.Where(x => cMS_DealerCities.Contains(x.CMS_DealerCity.))
            dealers = dealers.Distinct().ToList();
            List <QuotationViewModel> dealerViewModels = new List <QuotationViewModel>();

            foreach (CMS_DealerInfo cMS_DealerInfo in dealers)
            {
                QuotationViewModel dealerViewModel = new QuotationViewModel();
                dealerViewModel.DealerId     = cMS_DealerInfo.DealerId;
                dealerViewModel.RoleId       = cMS_DealerInfo.RoleId;
                dealerViewModel.CompanyName  = cMS_DealerInfo.CompanyName;
                dealerViewModel.CategoryName = CMSEntities.CMS_ProductCategoryMaster.Find(DealerProductId).CategoryName;
                dealerViewModel.ServiceName  = CMSEntities.CMS_ServiceMaster.Find(DealerServiceId).ServiceName;

                dealerViewModel.PerCategoryPrice = cMS_DealerInfo.CMS_DealerRate.Cast <CMS_DealerRate>().FirstOrDefault().PerCategoryPrice;
                dealerViewModel.PerServicePrice  = cMS_DealerInfo.CMS_DealerRate.Cast <CMS_DealerRate>().FirstOrDefault().PerServicePrice;
                dealerViewModel.PerKgPrice       = cMS_DealerInfo.CMS_DealerRate.Cast <CMS_DealerRate>().FirstOrDefault().PerKgPrice;
                dealerViewModel.PerKmPrice       = cMS_DealerInfo.CMS_DealerRate.Cast <CMS_DealerRate>().FirstOrDefault().PerKmPrice;
                dealerViewModels.Add(dealerViewModel);
            }
            return(dealerViewModels);
        }
Esempio n. 2
0
        /// <summary>
        /// Obtiene informacion de diferentes tablas en relacion a la cotizaciones
        /// </summary>
        /// <returns>Lista de cotizaciones</returns>
        public ActionResult QuotationList()
        {
            BostreamEntities1  db                 = new BostreamEntities1();
            List <Quotation>   quotationList      = db.Quotations.ToList();
            QuotationViewModel quotationViewModel = new QuotationViewModel();

            var list = (from q in db.Quotations
                        join c in db.Customers
                        on q.CustomerID equals c.CustomerID
                        join p in db.People
                        on c.PersonID equals p.PersonId
                        join s in db.Services
                        on q.ServiceID equals s.ServiceID
                        select new QuotationViewModel
            {
                CustomerID = c.CustomerID,
                Name = p.FirstName + " " + p.LastName,
                QuotationService = s.Name,
                CreationDate = q.CreationDate,
                ExpirationDate = q.ExpirationDate,
                Price = q.Price
            }).ToList();

            return(View(list));
        }
Esempio n. 3
0
 public ActionResult Index(QuotationViewModel qViewModel)
 {
     qViewModel.Enquiries = _enqRepo.GetEnquiryItemDetails(qViewModel.Enquiry.EnquiryId);
     _qRepo.GetQuotationTaskInfo(qViewModel.Quotation);
     qViewModel.Users = _enqRepo.drpGetUsers();
     return(View("Index", qViewModel));
 }
Esempio n. 4
0
        public PartialViewResult CloneTrainPassDetails(int quotationItemId)
        {
            QuotationViewModel qViewModel = new QuotationViewModel();

            try
            {
                qViewModel.Quotation = _qRepo.GetQuotationTrainDetailsById(quotationItemId);

                qViewModel.Quotation.QuotationItemPassDetail = _qRepo.GetQuotationTrainPassDetailsById(quotationItemId);

                Set_Date_Session(qViewModel.Quotation);

                qViewModel.Quotation.QuotationItemId = 0;

                qViewModel.Quotation.QuotationItemId = _qRepo.InsertTrainQuotationItemPass(qViewModel.Quotation);
            }
            catch (Exception ex)
            {
                qViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("Quotation Controller - CloneTrainTypeDetails  " + ex.Message);
            }

            TempData["enqViewModel"] = qViewModel;

            return(PartialView("_QuotationEnquiryItem", qViewModel));
        }
Esempio n. 5
0
        public PartialViewResult GetQuotationTrainPassDetailsById(int quotationItemId)
        {
            QuotationViewModel qViewModel = new QuotationViewModel();

            try
            {
                qViewModel.Quotation = _qRepo.GetQuotationTrainDetailsById(quotationItemId);

                qViewModel.Quotation.QuotationItemTypeDetail = _qRepo.GetQuotationTrainTypeDetailsById(quotationItemId);

                qViewModel.Quotation.QuotationItemPassDetail = _qRepo.GetQuotationTrainPassDetailsById(quotationItemId);
            }
            catch (Exception ex)
            {
                qViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("Quotation Controller - GetQuotationTrainDetailsById  " + ex.Message);
            }

            TempData["enqViewModel"] = qViewModel;

            qViewModel.Cities = _pRepo.drpGetCountryStateCity();

            qViewModel.Users = _enqRepo.drpGetUsers();

            return(PartialView("_AddTrainCTS", qViewModel));
        }
Esempio n. 6
0
        public PartialViewResult GetEnquiryFlightDetailsById(int enquiryItemId)
        {
            QuotationViewModel qViewModel = new QuotationViewModel();

            try
            {
                qViewModel.Enquiry = _qRepo.GetFlightDetailsById(enquiryItemId);

                //qViewModel.Enquiry.EnquiryItemTypeDetails = _enqRepo.GetFlightTypeDetailsById(enquiryItemId);
            }
            catch (Exception ex)
            {
                qViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("Enquiry Controller - GetFitDetailsById  " + ex.Message);
            }

            TempData["qViewModel"] = qViewModel;

            qViewModel.Cities = _pRepo.drpGetCountryStateCity();

            qViewModel.Users = _enqRepo.drpGetUsers();

            return(PartialView("_AddFlightCTS", qViewModel));
        }
Esempio n. 7
0
        public JsonResult InsertQuotationItem(QuotationViewModel qViewModel)
        {
            try
            {
                Set_Date_Session(qViewModel.Quotation);

                if (qViewModel.Quotation.QuotationId == 0)
                {
                    qViewModel.Quotation.QuotationId = _qRepo.InsertQuotationBasic(qViewModel.Quotation);

                    _qRepo.InsertQuotationTask(qViewModel.Quotation);
                }

                qViewModel.Quotation.QuotationItemId = _qRepo.InsertQuotationItem(qViewModel.Quotation);

                qViewModel.FriendlyMessage.Add(MessageStore.Get("Q04"));

                Logger.Debug("Quotation Controller InsertQuotationItem");
            }
            catch (Exception ex)
            {
                qViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("Quotation Controller - InsertQuotationItem " + ex.Message);
            }

            return(Json(qViewModel));
        }
        /// <summary>
        /// Request new Quotation
        /// </summary>
        /// <param name="model"></param>
        public void RequestQuote(QuotationViewModel model)
        {
            Buyer buyer = new Buyer();

            if (model.BuyerId != null)
            {
                // retrieve existing buyer
                buyer = _buyerRepository.GetById(model.BuyerId.Value);
            }
            else
            {
                // create a new buyer and add it to the db
                buyer = _buyerRepository.Add(new Buyer(model.FullName, model.ContactEmail, model.PhoneNumber)
                {
                    ShippingAddress = new Address(model.StreetAddress, model.City, model.State, model.Country, model.ZipCode),
                    BillingAddress  = new Address(model.StreetAddress, model.City, model.State, model.Country, model.ZipCode)
                });
            }

            List <OrderItem> orderItems = model.OrderItems
                                          .Select(o => new OrderItem {
                PartNumber = o.PartNumber, Quantity = o.Quantity
            }).ToList();

            _orderService.CreateOrder(buyer.Id, orderItems);
        }
Esempio n. 9
0
        public async Task <ActionResult> CreateQuote(Guid?id, string search = null)
        {
            try
            {
                var model = await _quote.GetRequestQuoteToEdit((Guid)id);

                QuotationViewModel quotation = new QuotationViewModel();
                quotation.ReferenceNumber    = model.ReferenceNumber;
                quotation.ProjectName        = model.ProjectName;
                quotation.ProjectDescription = model.ProjectDescription;
                quotation.ClientId           = model.ClientId;
                quotation.Documents          = model.ProjectDocuments;
                quotation.QuoteRequestId     = model.Id;

                quotation.Foreman = "1";
                //quotation.GeneralWorkers = "1";

                quotation.QuoteMaterials = await _quote.GetQuoteMaterials((Guid)id, search);

                quotation.QuoteEquipments = await _quote.GetQuoteEquipments((Guid)id, search);

                // if you want  eg 5 items loaded initial (ToPagedList, 5)
                quotation.QuoteMaterials  = quotation.QuoteMaterials.ToPagedList(1, 2);
                quotation.QuoteEquipments = quotation.QuoteEquipments.ToPagedList(1, 2);
                return(View(quotation));
            }
            catch
            {
                return(RedirectToAction("BadRequest", "Home"));
            }
        }
 public void BuildSelectLists(QuotationViewModel quotationViewModel)
 {
     quotationViewModel.PaymentTermDropDown = paymentTermSelectListBuilder.BuildSelectListItemsForPaymentTerms(paymentTermRepository.GetAllPaymentTerms());
     quotationViewModel.PersonInChargeDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
     quotationViewModel.ApproverDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
     quotationViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
 }
Esempio n. 11
0
        public QuotationReport(QuotationViewModel viewModel)
        {
            InitializeComponent();

            DataContext = viewModel;
            vm          = viewModel;
        }
        private void SetUsersSession(SessionInfo session)
        {
            QuotationViewModel qsViewModel = new QuotationViewModel();

            try
            {
                Logger.Debug("Authentication Controller SetUserSession");

                if (HttpContext.Session["SessionInfo"] == null)
                {
                    HttpContext.Session.Add("SessionInfo", session);
                    HttpContext.Session.Add("BookingCart", qsViewModel.Quotation.QuatationItem);
                }
                else
                {
                    HttpContext.Session["SessionInfo"] = session;
                }
            }
            catch (Exception ex)
            {
                UserViewModel homeViewModel = new UserViewModel();

                homeViewModel.FriendlyMessage.Add(MessageStore.Get("UM004"));

                Logger.Error("Authentication Controller - Set Session " + ex.Message);

                TempData["homeViewModel"] = homeViewModel;

                HttpContext.Session.Clear();
            }
        }
        public void TestInitialize()
        {
            _panel1 = new PanelViewModel(new Panel())
            {
                Price      = 5,
                Time       = 5,
                TotalPrice = 5,
            };

            _panel2 = new PanelViewModel(new Panel())
            {
            };

            _quotationStatus = new QuotationStatus(new DateTime(), QuotationStatusType.Created);

            _quotation = new Quotation(_quotationStatus)
            {
                PriceDifference   = 50,
                HourPrice         = 200,
                BasePrice         = 50,
                ContributionRatio = 0.5,
            };

            _quotationViewModel = new QuotationViewModel(_quotation);
        }
 public void OnNavigatedTo(NavigationContext navigationContext)
 {
     if (navigationContext.NavigationService.Region.Name == RegionNames.MainRegion)
     {
         QuotationViewModel = new QuotationViewModel(quotationDb);
     }
 }
 public void BuildSelectLists(QuotationViewModel quotationViewModel)
 {
     quotationViewModel.PaymentTermDropDown    = paymentTermSelectListBuilder.BuildSelectListItemsForPaymentTerms(paymentTermRepository.GetAllPaymentTerms());
     quotationViewModel.PersonInChargeDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
     quotationViewModel.ApproverDropDown       = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
     quotationViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), quotationViewModel.UserID);
 }
Esempio n. 16
0
        public JsonResult Update(QuotationViewModel qViewModel)
        {
            try
            {
                Set_Date_Session(qViewModel.Quotation);

                _qRepo.UpdateQuotationBasic(qViewModel.Quotation);
                if (qViewModel.IsApproval && qViewModel.QuotaionItems != null && qViewModel.QuotaionItems.Any())
                {
                    foreach (var item in qViewModel.QuotaionItems)
                    {
                        Set_Date_Session(item);
                        _qRepo.UpdateQuotationItemStatus(item);
                    }
                    SendApprovedQuotationEmail(qViewModel.Quotation.QuotationId);
                }

                qViewModel.FriendlyMessage.Add(MessageStore.Get("Q02"));

                Logger.Debug("Quotation Controller UpdateQuotation");
            }
            catch (Exception ex)
            {
                qViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("Quotation Controller - UpdateQuotation  " + ex.Message);
            }

            return(Json(qViewModel));
            //return RedirectToAction("Index");
        }
Esempio n. 17
0
 public QuotationPage()
 {
     InitializeComponent();
     viewModel     = new QuotationViewModel();
     DataContext   = viewModel;
     quotationPage = this;
 }
Esempio n. 18
0
        public PartialViewResult AddFlightCTS(QuotationViewModel qViewModel)
        {
            qViewModel.Cities = _pRepo.drpGetCountryStateCity();

            qViewModel.Users = _enqRepo.drpGetUsers();

            return(PartialView("_AddFlightCTS", qViewModel));
        }
Esempio n. 19
0
        public async Task <PartialViewResult> PagedMarterial(Guid id, int?page)
        {
            QuotationViewModel quotation = new QuotationViewModel();

            quotation.QuoteMaterials = await _quote.GetQuoteMaterials(id, null);

            quotation.QuoteMaterials = quotation.QuoteMaterials.ToPagedList(page ?? 1, 2);
            return(PartialView("_LoadMoreMaterial", quotation));
        }
Esempio n. 20
0
        public async Task <PartialViewResult> PagedEquiptment(Guid id, int?page)
        {
            QuotationViewModel quotation = new QuotationViewModel();

            quotation.QuoteEquipments = await _quote.GetQuoteEquipments(id, null);

            quotation.QuoteEquipments = quotation.QuoteEquipments.ToPagedList(page ?? 1, 2);
            return(PartialView("_LoadMoreEquiptment", quotation));
        }
Esempio n. 21
0
 /// <summary>
 /// Initialize a new Quotation Report
 /// </summary>
 /// <param name="quoteFor">Specify the particular quotations that you are Reporting on
 /// All for allClients and Client for a particular client</param>
 /// <param name="viewModel">The ViewModel where all data is taken from</param>
 /// <param name="_who">Specifies who the quotation is for to be displayed on the form</param>
 public QuotationsReport(string quoteFor, QuotationViewModel viewModel, string _who)
 {
     InitializeComponent();
     DataContext              = viewModel;
     vm                       = viewModel;
     DcQutations.Who          = _who;
     DcQutations.DateChanged += DcQutations_DateChanged;
     currentContext           = SynchronizationContext.Current;
     QuoteFor                 = quoteFor;
     DcQutations.Month        = 0;
 }
Esempio n. 22
0
        // GET: Quotations/Create
        public ActionResult Create(int?id)
        {
            Customer customer = db.Customers.SingleOrDefault(x => x.Id == id);

            QuotationViewModel model = new QuotationViewModel();

            model.CustomerId   = customer.Id;
            model.CustomerName = customer.Name;

            return(View(model));
        }
Esempio n. 23
0
        public async Task <PartialViewResult> SearchEquiptment(Guid id, string searchTerm)
        {
            if (searchTerm == "undefined" || searchTerm == "")
            {
                searchTerm = null;
            }
            QuotationViewModel quotation = new QuotationViewModel();

            quotation.QuoteEquipments = await _quote.GetQuoteEquipments(id, searchTerm);

            return(PartialView("_EquiptmentPartial", quotation));
        }
Esempio n. 24
0
        public async Task <PartialViewResult> SearchMarterial(Guid id, string searchTerm)
        {
            if (searchTerm == "undefined" || searchTerm == "")
            {
                searchTerm = null;
            }
            QuotationViewModel quotation = new QuotationViewModel();

            quotation.QuoteMaterials = await _quote.GetQuoteMaterials(id, searchTerm);

            return(PartialView("_MaterialPartial", quotation));
        }
Esempio n. 25
0
 public ActionResult Edit(QuotationViewModel quotation)
 {
     if (ModelState.IsValid)
     {
         var entity = Mapper.Map <Quotation>(quotation);
         quotationService.Update(entity);
         return(RedirectToAction("Index"));
     }
     ViewBag.CustomerId = new SelectList(customerService.GetAll(), "Id", "FullName");
     ViewBag.ProductId  = new SelectList(productService.GetAll(), "Id", "Name");
     ViewBag.TaxId      = new SelectList(taxService.GetAll(), "Id", "Name");
     return(View(quotation));
 }
        public IActionResult Index(int pageNumber = 1, QuotationSortType sortOrder = QuotationSortType.None, QuotationFilterData filterData = null)
        {
            var paginationData = new PaginationData(pageNumber);

            var quotations      = QuotationRepository.Get(sortOrder, filterData, paginationData).ToList();
            var quotationModels = Mapper.Map <List <QuotationModel> >(quotations);

            var quotationCount  = QuotationRepository.GetTotalCount(sortOrder, filterData);
            var paginationModel = new PaginationModel(paginationData, quotationCount);

            var model = new QuotationViewModel(quotationModels, sortOrder, filterData, paginationModel);

            return(View("Index", model));
        }
Esempio n. 27
0
        // GET: Quotations/Details/5
        public ActionResult Details(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            QuotationViewModel quotation = Mapper.Map <QuotationViewModel>(quotationService.Get(id.Value));

            if (quotation == null)
            {
                return(HttpNotFound());
            }
            return(View(quotation));
        }
        public JsonResult SupplierAddToCart(QuotationViewModel qViewModel)
        {
            QuotationViewModel qsViewModel = new QuotationViewModel();


            JavaScriptSerializer json_serializer = new JavaScriptSerializer();

            try
            {
                if (Request.Cookies["Bookings"].Value != null)
                {
                    if (Request.Cookies["Bookings"].Value != "")
                    {
                        qsViewModel.Quotation.QuatationItem = json_serializer.Deserialize <List <BookingCartDetailsInfo> >(Request.Cookies["Bookings"].Value);

                        string PackageName = qViewModel.Quotation.QuatationItem.Select(x => x.PackageName).FirstOrDefault();

                        if (!qsViewModel.Quotation.QuatationItem.Where(x => x.PackageName == PackageName).Any())
                        {
                            qsViewModel.Quotation.QuatationItem.AddRange(qViewModel.Quotation.QuatationItem);

                            string jsonData = json_serializer.Serialize(qsViewModel.Quotation.QuatationItem);

                            Response.Cookies["Bookings"].Value = jsonData;

                            HttpContext.Response.SetCookie(Response.Cookies["Bookings"]);
                        }
                    }
                    else
                    {
                        string jsonData = json_serializer.Serialize(qViewModel.Quotation.QuatationItem);

                        Response.Cookies["Bookings"].Value = jsonData;

                        HttpContext.Response.SetCookie(Response.Cookies["Bookings"]);
                    }
                }
            }
            catch (Exception ex)
            {
                qsViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01"));

                Logger.Error("SupplierSearch Controller - HotelAddToCart" + ex.ToString());

                Request.Cookies["Bookings"].Value = null;
            }

            return(Json(qsViewModel, JsonRequestBehavior.AllowGet));
        }
Esempio n. 29
0
        protected override void OnNavigatedTo(NavigationEventArgs e)
        {
            int quotationId = (e.Parameter as int?).Value;

            PageHelper.DoAsync(overlay, Dispatcher, () =>
            {
                QuotationViewModel.LoadQuotationByPK(quotationId);


                PageHelper.MainUI(Dispatcher, () =>
                {
                    this.Bindings.Update();
                });
            });
        }
Esempio n. 30
0
        public ActionResult DeleteConfirmed(int id, int customerId)
        {
            Quotation quotation = db.Quotations.Include("FileData").SingleOrDefault(x => x.Id == id);

            QuotationViewModel vm = new QuotationViewModel
            {
                Id         = quotation.Id,
                Name       = quotation.Name,
                CustomerId = customerId
            };

            db.FileDatas.Remove(quotation.FileData);
            db.Quotations.Remove(quotation);
            db.SaveChanges();
            return(RedirectToAction("Details", "Customers", new { id = customerId }));
        }
 private void OnOpenQuotationEvent(QuotationEventArgs arg)
 {
     if (arg != null && arg.QuotationDataSet != null && arg.QuotationDataSet.Tables.Count == 4 && arg.QuotationDataSet.Tables[0].Rows.Count > 0)
     {
         QuotationViewModel = new QuotationViewModel(quotationDb, arg.QuotationDataSet);
         if (this.QuotationViewModel != null)
         {
             string qNo = this.QuotationViewModel.CurrentInsuranceDetail.InsuranceQtnNo;
             QuotationNo = string.Format("Quotation No : {0}", qNo);
         }
         ClearRegions(arg.RegionName);
         this.RegionManager.RequestNavigate(arg.RegionName, arg.Source);
     }
     else
     {
     }
 }