public void LoadCreditCardTypes() { var service = new LookUpService(); var allcardTypes = service.GetAllCreditCardTypes(); Assert.IsTrue(allcardTypes.Count > 0); }
internal static List <string> GenerateCountryIDs() { var service = new LookUpService(); var countries = service.GetAllCountries(); return(countries.Select(c => c.CountryID.TrimEnd()).OrderBy(c => c).ToList()); }
public string GetAmazonServerName(string ipAddress) { string getCountry = LookUpService.GetCountry(ipAddress).ToLower(); string getServerName = (string)HttpContext.Current.Cache[getCountry + "-serverName"]; if (string.IsNullOrEmpty(getServerName)) { using (Searchwar_netEntities db = new Searchwar_netEntities()) { AmazonServerolumnNoPosition paramaters = new AmazonServerolumnNoPosition() { getCountry = getCountry }; getServerName = GetFastServerName.Invoke(db, paramaters).ToString(); } HttpContext.Current.Cache.Add(getCountry + "-serverName", getServerName, null, TimeZoneManager.DateTimeNow.AddDays(10), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null); } return(getServerName); }
internal static List <string> GenerateStateIDsByCountry(string countryId) { var service = new LookUpService(); var states = service.GetStatesByCountryID(countryId); return(states); }
public async Task ICanGetAllDropDownValuesForRouteStatus() { var svc = new LookUpService(); var result = await svc.GetAllRouteFilters((int)RouteFilterTypes.RouteStatus); Assert.IsTrue(result.Count > 0); }
public void GetCountryWithStatesRelationship() { var service = new LookUpService(); var countries = service.GetAllCountries(); Assert.IsTrue(countries.Count > 0); Assert.IsTrue(countries.First().States.Count > 0); }
public TurboTenKeyControl() { InitializeComponent(); service = new LookUpService(); tapes = new List <Tape>(); batches = new List <Batch>(); }
public async Task <JsonResult> ConceptsForCenter(int SygmaCenterNumber) { var model = await LookUpService.GetConceptsForCenter(SygmaCenterNumber); model = model.OrderBy(o => o.Concept).ToList(); return(Json(JsonConvert.SerializeObject(model), JsonRequestBehavior.AllowGet)); //return Json(List<ConceptType>RouteFilterService.GetConceptsForCenter(SygmaCenterNumber)); }
public void LoadGroupByGroupIDShouldReturnData() { var service = new LookUpService(); var group = service.GetGroupByGroupID("Nerds"); Assert.IsNotNull(group); Assert.IsNotNull(group.Users.FirstOrDefault(c => c.UserID == "DomingoG")); }
public async Task <ActionResult> List(SearchRouteSortableViewModel criteria) { var model = new RouteListViewModel(await RouteService.SearchAsync(criteria)) { RouteColumnOption = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERROUTES"), ColumnTypes.Route) }; return(PartialView("_routeList", model)); }
public async Task <ActionResult> Stops(int routeId) { var routeWithStops = await RouteService.GetByRouteIdAsync(routeId); var model = new RouteStopViewModel(routeWithStops) { StopColumnOption = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERSTOPS"), ColumnTypes.Stop) }; return(PartialView("_stopList", model)); }
private Tuple <int, int> GetWarehouseAndTerritory(string state) { var lookupService = new LookUpService(); var branchID = lookupService.GetBranchIDByState(state); var warehouses = lookupService.GetBranches(); var whseKey = warehouses.FirstOrDefault(wh => wh.BranchID == branchID).Key; var salesTerritoryKey = warehouses.FirstOrDefault(wh => wh.BranchID == branchID).SalesTerritoryKey; return(new Tuple <int, int>(whseKey, salesTerritoryKey)); }
public async Task <ActionResult> ColumnOption() { var rco = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERROUTES"), ColumnTypes.Route); var sco = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERSTOPS"), ColumnTypes.Stop); RouteTrackerColumnOptionViewModel model = new RouteTrackerColumnOptionViewModel { RouteColumnOption = rco, StopColumnOption = sco }; return(PartialView("_trackerColumnOptions", model)); }
//PUBLIC FUNCTIONS public void Initialize(int _custKey, Module _module) { service = new CustomerService(); luService = new LookUpService(); cardTypes = luService.GetAllCreditCardTypes(); customer = service.LoadCustomer(_custKey); creditCards = service.LoadCreditCardsByCustKey(_custKey); selectedCard = creditCards.Count > 0 ? creditCards.FirstOrDefault(c => c.Preferred == -1) : new CreditCard(); module = _module; custKey = _custKey; SelectPreferredCard(); }
public async Task <ActionResult> Index() { if (CurrentAPIEnvironment != "PROD") { ViewBag.Title = $"Route Tracker (ATM VER: {ViewBag.Version}, API: {CurrentAPIEnvironment})"; } else { ViewBag.Title = "Route Tracker"; } var ModifiedTypes = new List <SelectListItem> { new SelectListItem { Text = "Removed", Value = "removed" }, new SelectListItem { Text = "Added", Value = "added" }, new SelectListItem { Text = "Time Adjusted", Value = "timeChanged" } }; var model = new RouteTrackerViewModel { CenterSelectList = new SelectList(await CenterService.GetAll(UserName), "SygmaCenterNo", "Center"), //FilterByDispatchDay = new MultiSelectList((await LookUpService.GetAllRouteFilters((int)RouteFilterTypes.RouteNumbers)).OrderBy(x => x.DisplayOrder), "Value", "Text"), ModifiedTypeSelectList = new SelectList(ModifiedTypes, "Value", "Text"), ConceptTypeList = new SelectList(await LookUpService.GetAllConcepts(), "ConceptId", "Concept") }; var dates = (await LookUpService.GetAllRouteFilters((int)RouteFilterTypes.DateRange)).Where(s => s.IsActive == 1).OrderBy(x => x.DisplayOrder); foreach (var d in dates) { if (d.Value == "0") { d.Text = d.Text + " - " + (((((int)DateTime.Today.DayOfWeek)) % 7) + 1).ToString() + "00s"; } else if (d.Value == "1") { d.Text = d.Text + " - " + (((((int)DateTime.Today.DayOfWeek) + 1) % 7) + 1).ToString() + "00s"; } else if (d.Value == "3") { d.Text = d.Text + " - " + (DateTime.Today.DayOfWeek == DayOfWeek.Sunday ? "7" : (((((int)DateTime.Today.DayOfWeek) - 1) % 7) + 1).ToString()) + "00s"; } } model.DateRangeList = new SelectList(dates, "Value", "Text"); return(View(model)); }
//-----------------------LOAD------------------------- private void Billing_Load(object sender, EventArgs e) { settings = new AccountSettings(); service = new LookUpService(); var custClasses = service.GetCustClasses(); custClass = custClasses.FirstOrDefault(c => c.Key == CustClassKey); custTypes = service.GetCustClasses(); paymentTerms = service.GetPaymentTerms(); shipMethods = service.GetShipMethods(); //do we need? invoiceCopies = service.GetDistinctInvoiceCopies(); invoiceCopies = invoiceCopies.OrderBy(c => c).ToList(); invoiceCopies.Insert(0, ""); invoiceCopies.RemoveAll(c => c == null); cboPaymentTerms.DisplayMember = "Id"; cboPaymentTerms.ValueMember = "Key"; cboPaymentTerms.DataSource = paymentTerms; cboShipMethod.DisplayMember = "ShipMethID"; cboShipMethod.ValueMember = "Key"; cboShipMethod.DataSource = shipMethods; lblStatus.Text = "Set additional account settings."; lblStatus.ForeColor = Color.Red; if (CustClassKey == 0) { rdoEndUser.Checked = true; } else { SetControlsFromPassedInFields(); } containerValidator.Validate(); }
private void SetTaxRateTextBox() { if (currentCustAddress.TaxSchedule == null) { var lookup = new LookUpService(); if (currentCustAddress.STaxSchdKey != null) { var schdKey = (int)currentCustAddress.STaxSchdKey; var taxSchedule = lookup.GetTaxScheduleByKey(schdKey); txtTaxRate.Text = string.Format("{0:G29} %", taxSchedule.Rate); } else { txtTaxRate.Text = string.Format("0.0 %"); } } else { var taxSchedule = currentCustAddress.TaxSchedule; txtTaxRate.Text = string.Format("{0:G29} %", taxSchedule.Rate); } }
public async Task <ActionResult> MovedStopPopup(int routePlanId, int modifiedType) { //call service layer to get collection of stops with the route plan ID var matchingStopCollection = new List <Stop>(await RouteService.GetStopsByRoutePlanIdAsync(routePlanId)); //stop collection should only ever have 2 entries if (matchingStopCollection.Count != 2) { throw new UnexpectedStopException("An unexpected number of Stops was encountered"); } //decide which stop is destination based on direction you are coming from int desiredRouteId = matchingStopCollection.First(s => s.RoutePlanModificationTypeId != modifiedType).RouteId; //get route info from routeID var model = new MovedStopPopupRouteStopViewModel(await RouteService.GetByRouteIdAsync(desiredRouteId)) { //need both route and stop column options StopColumnOption = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERSTOPS"), ColumnTypes.Stop), RouteColumnOption = new ColumnOptionViewModel(await LookUpService.GetColumnOptionsForUserAndPage(UserName, "ROUTETRACKERROUTES"), ColumnTypes.Route) }; //send model of route info to popup return(PartialView("_movedStopPopup", model)); }
public async Task SaveColumnOption(UpdateRouteTrackerColumnOptionViewModel model) { await LookUpService.UpdateColumnOptionAsync(UserName, "ROUTETRACKERROUTES", JsonConvert.SerializeObject(model.RouteColumnOption)); await LookUpService.UpdateColumnOptionAsync(UserName, "ROUTETRACKERSTOPS", JsonConvert.SerializeObject(model.StopColumnOption)); }
public void AddCustomerWithDependencies() { var custId = "VMLOP91900-2"; var custService = new CustomerService(); var lookupService = new LookUpService(); var custclasses = lookupService.GetCustClasses(); var dealerCustClass = custclasses.Where(c => c.Key == 40).First(); var primaryAddress = GetHydratedAddress("877 Monterey Pass Road"); var primaryCustAddress = GetHydratedCustAddress(dealerCustClass, API.Enums.CustAddrType.Primary); var billtoAddress = GetHydratedAddress("875 Monterey Pass Road"); var billtoCustAddress = GetHydratedCustAddress(dealerCustClass, API.Enums.CustAddrType.BillTo); var shiptoAddress = GetHydratedAddress("876 Monterey Pass Road"); var shiptoCustAddress = GetHydratedCustAddress(dealerCustClass, API.Enums.CustAddrType.ShipTo); var primaryContact = new Contact() { Name = "Victor Lopez", FirstName = "Victor", LastName = "Lopez", Title = "Accounting", Email = "*****@*****.**", MobilePhone = "6262325365", Phone = "6262325365", PhoneExt = "", Fax = "", FaxExt = "", CCCreditMemo = 0, CCCustStmnt = 0, CCDebitMemo = 0, CCEFTRemittance = 0, CCFinanceCharge = 0, CCInvoice = 0, CCPurchaseOrder = 0, CCRMA = 0, CCSalesOrder = 0, Deleted = 0, EMailFormat = 3, EntityType = 501, UpdateCounter = 1 }; var newCustomer = new Customer(); newCustomer.PrimaryAddress = primaryAddress; newCustomer.DefaultBillToAddress = billtoAddress; newCustomer.DefaultShipToAddress = shiptoAddress; newCustomer.PrimaryContact = primaryContact; //newCustomer.Contacts = new List<Contact>(); //newCustomer.Contacts.Add(primaryContact); newCustomer.Id = custId; newCustomer.AllowCustRefund = dealerCustClass.AllowCustRefund; newCustomer.AllowWriteOff = dealerCustClass.AllowWriteOff; newCustomer.BillingType = dealerCustClass.BillingType; newCustomer.BillToNationalAcctParent = 0; newCustomer.CompanyId = "CPC"; newCustomer.ConsolidatedStatement = 0; newCustomer.CreateDate = DateTime.Now; newCustomer.CreateUserID = Environment.UserName; newCustomer.CreateType = 1; newCustomer.CreditLimit = dealerCustClass.CreditLimit; newCustomer.CreditLimitAgeCat = dealerCustClass.CreditLimitAgeCat; newCustomer.CreditLimitUsed = 1; newCustomer.CustClassKey = dealerCustClass.Key; newCustomer.DateEstab = DateTime.Now; newCustomer.DfltSalesAcctKey = dealerCustClass.DfltSalesAcctKey; newCustomer.DfltMaxUpCharge = 0; newCustomer.DfltMaxUpChargeType = 0; newCustomer.Name = "Victor Refrig"; newCustomer.FinChgFlatAmt = dealerCustClass.FinChgFlatAmt; newCustomer.FinChgPct = dealerCustClass.FinChgPct; newCustomer.Hold = 0; newCustomer.PmtByNationalAcctParent = 0; newCustomer.PrintDunnMsg = dealerCustClass.PrintDunnMsg; newCustomer.ReqCreditLimit = 0; newCustomer.ReqPO = dealerCustClass.ReqPO; newCustomer.RetntPct = dealerCustClass.RetntPct; newCustomer.StmtCycleKey = dealerCustClass.StmtCycleKey; newCustomer.StmtFormKey = dealerCustClass.StmtFormKey; newCustomer.ShipPriority = 3; newCustomer.Status = 1; newCustomer.StmtFormKey = dealerCustClass.StmtFormKey; newCustomer.TradeDiscPct = dealerCustClass.TradeDiscPct; newCustomer.UpdateCounter = 1; //newCustomer.UserFld2 = accountSettings.PricePackSlip; //newCustomer.SalesSourceKey = accountSettings.SalesSourceKey; newCustomer.CustAddresses = new List <CustAddress>(); newCustomer.CustAddresses.Add(primaryCustAddress); newCustomer.CustAddresses.Add(billtoCustAddress); newCustomer.CustAddresses.Add(shiptoCustAddress); var transmittals = new List <DocTransmittal> { new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 501 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 502 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 503 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 505 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 522 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 801 }, new DocTransmittal { EMail = 0, EMailFormat = 3, Fax = 0, HardCopy = 0, IncludeCC = 0, TranType = 835 } }; newCustomer.DocTransmittals = new List <DocTransmittal>(); newCustomer.DocTransmittals.AddRange(transmittals); custService.AddCustomerWithDependencies(newCustomer); }
public void AddCustAddressAndAssignDefaultShipTo() { var service = new CustomerService(); var lookupService = new LookUpService(); var custClass = lookupService.GetCustClasses().First(); var custAddress = new CustAddress(); custAddress.AllowInvtSubst = custClass.AllowInvtSubst; custAddress.BackOrdPrice = 0; custAddress.BOLReqd = 0; custAddress.CarrierBillMeth = 6; custAddress.CloseSOLineOnFirstShip = 0; custAddress.CloseSOOnFirstShip = 0; custAddress.CreateDate = DateTime.Now; custAddress.CreateType = 0; custAddress.CreateUserID = Environment.UserName; custAddress.CurrID = custClass.CurrID; custAddress.CustAddrID = "Test"; custAddress.CustKey = 65932; custAddress.FOBKey = custClass.FOBKey; custAddress.FreightMethod = 2; custAddress.InvoiceReqd = 0; custAddress.LanguageID = custClass.LanguageID; custAddress.PackListContentsReqd = 0; custAddress.PackListReqd = 0; custAddress.PriceAdj = 0; custAddress.PriceBase = 0; custAddress.PrintOrderAck = 0; custAddress.RequireSOAck = custClass.RequireSOAck; custAddress.ShipComplete = custClass.ShipComplete; custAddress.ShipDays = 3; custAddress.ShipLabelFormKey = custClass.ShipLabelFormKey; custAddress.ShipLabelsReqd = 0; custAddress.SOAckFormKey = custClass.SOAckFormKey; custAddress.SOAckMeth = 0; custAddress.SperKey = custClass.SperKey; custAddress.WhseKey = 23; custAddress.UsePromoPrice = 0; custAddress.ShipMethKey = custClass.ShipMethKey; custAddress.InvcFormKey = custClass.InvcFormKey; custAddress.PackListFormKey = 84; custAddress.SalesTerritoryKey = 2; var address = new Address() { Name = "Case Parts", Line1 = "877 Monterey Pass Rd", City = "Monterey Park", State = "CA", Zip = "91754", Country = "USA", Residential = 1, TransactionOverride = 0, UpdateCounter = 1 }; custAddress.Address = address; Customer customer = service.LoadCustomerWithDependenciesByKey(29301); service.InsertCustAddrAndAssignCustomerDefaultAddress(customer, custAddress, true, true); Assert.IsTrue(true); }