public static void InitializeDropDowns(CashOrderViewModel model) { using (FreeMarketEntities db = new FreeMarketEntities()) { model.Custodians = db.Custodians.Select (c => new SelectListItem { Text = c.CustodianName, Value = c.CustodianNumber.ToString() }).ToList(); foreach (Product product in model.Products.Products) { string normalPrice = string.Format("{0:C}", product.PricePerUnit); string specialPrice = string.Format("{0:C}", product.SpecialPricePerUnit); product.Prices = new List <SelectListItem>(); product.Prices.Add(new SelectListItem { Text = normalPrice, Value = product.PricePerUnit.ToString() }); product.Prices.Add(new SelectListItem { Text = specialPrice, Value = product.SpecialPricePerUnit.ToString(), Selected = true }); } } }
public void CancelOrder(string userId) { using (FreeMarketEntities db = new FreeMarketEntities()) { OrderHeader order = db.OrderHeaders.Find(Order.OrderNumber); if (order == null) { return; } order.OrderStatus = "Cancelled"; db.Entry(order).State = EntityState.Modified; db.SaveChanges(); foreach (OrderDetail temp in Body.OrderDetails) { temp.OrderItemStatus = "Cancelled"; db.Entry(temp).State = EntityState.Modified; } db.SaveChanges(); } Initialize(userId); }
public static List <SiteConfiguration> GetSiteConfig() { using (FreeMarketEntities db = new FreeMarketEntities()) { return(db.SiteConfigurations.OrderBy(c => c.Key).ToList()); } }
private void CalculateNumberOfItems(DateTime date) { using (FreeMarketEntities db = new FreeMarketEntities()) { NumberOrdersSingleItem = 0; NumberOrdersTwoToFive = 0; NumberOrdersGreaterFive = 0; List <GetNumberOfItemsStatistic_Result> result = db.GetNumberOfItemsStatistic().ToList(); foreach (GetNumberOfItemsStatistic_Result res in result) { if (res.OrderDatePlaced.HasValue && res.OrderDatePlaced.Value.Year == date.Year && res.OrderDatePlaced.Value.Month == date.Month) { if (res.SumItems == 1) { NumberOrdersSingleItem++; } else if (res.SumItems > 1 && res.SumItems <= 5) { NumberOrdersTwoToFive++; } else { NumberOrdersGreaterFive++; } } } } }
public static ProductCollectionPaged SetAllProductDataDistinctFilter(int pageNumber, int pageSize, List <GetAllProductsDistinctFilter_Result> allProducts) { ProductCollectionPaged collection = new ProductCollectionPaged(); List <Product> temp = new List <Product>(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (allProducts != null && allProducts.Count > 0) { foreach (GetAllProductsDistinctFilter_Result product in allProducts) { Product prodTemp = Product.GetShallowProduct((int)product.ProductNumber, (int)product.SupplierNumber); prodTemp.MinPrice = product.minPrice; prodTemp.MaxPrice = product.maxPrice; if (prodTemp != null) { temp.Add(prodTemp); } } } collection.Products = (PagedList <Product>)temp.ToPagedList(pageNumber, pageSize); return(collection); } }
public static void SetDepartmentData(List <Department> departments) { using (FreeMarketEntities db = new FreeMarketEntities()) { foreach (Department department in departments) { int imageNumber = db.DepartmentPictures .Where(c => c.DepartmentNumber == department.DepartmentNumber && c.Dimensions == PictureSize.Medium.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); int imageNumberSecondary = db.DepartmentPictures .Where(c => c.DepartmentNumber == department.DepartmentNumber && c.Dimensions == PictureSize.Large.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); department.MainImageNumber = imageNumber; department.SecondaryImageNumber = imageNumberSecondary; department.ItemsInDepartment = db.Products .Where(c => c.DepartmentNumber == department.DepartmentNumber) .Count(); } } }
public static CustomerAddress GetCustomerAddress(string userId, string addressName) { CustomerAddress address = new CustomerAddress(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (!string.IsNullOrEmpty(addressName)) { address = db.CustomerAddresses.Where(c => c.CustomerNumber == userId && c.AddressName == addressName) .FirstOrDefault(); } else { address = db.CustomerAddresses.Where(c => c.CustomerNumber == userId) .FirstOrDefault(); } } if (address == null) { address = new CustomerAddress(); } return(address); }
public static ProductCollectionPaged SetProductDataDistinct(int pageNumber, int pageSize, List <GetAllProductsByDepartmentDistinct_Result> allProducts) { ProductCollectionPaged collection = new ProductCollectionPaged(); List <Product> temp = new List <Product>(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (allProducts != null && allProducts.Count > 0) { foreach (GetAllProductsByDepartmentDistinct_Result product in allProducts) { Product prodTemp = Product.GetShallowProduct(product.ProductNumber, product.SupplierNumber); prodTemp.MinPrice = product.minPrice; prodTemp.MaxPrice = product.maxPrice; PopularProduct pp = db.PopularProducts.Where(c => c.ProductNumber == prodTemp.ProductNumber && c.SupplierNumber == prodTemp.SupplierNumber).FirstOrDefault(); if (pp != null) { prodTemp.NumberSold = pp.NumberSold ?? 0; } if (prodTemp != null) { temp.Add(prodTemp); } } } collection.Products = (PagedList <Product>)temp.ToPagedList(pageNumber, pageSize); return(collection); } }
public static void LogException(Exception e) { var currentUserName = HttpContext.Current.User.Identity.GetUserId() ?? "Anonymous"; ExceptionLogging ex = new ExceptionLogging() { DateTime = System.DateTime.Now, Identity = currentUserName, Message = e.Message, StackTrace = e.StackTrace }; try { using (FreeMarketEntities db = new FreeMarketEntities()) { db.ExceptionLoggings.Add(ex); db.SaveChanges(); } } catch { // Could not log error ex.ExceptionNumber = 999999; } finally { System.Diagnostics.Debug.Write(string.Format("Exception swallowed by Filter: {0}", ex)); if ((ConfigurationManager.AppSettings["notifyDeveloperOfExceptions"]) == "true") { NotifyDeveloper(ex); } } }
public static async void LogExceptionAsync(Exception e) { var currentUserName = HttpContext.Current.User.Identity.GetUserId() ?? "Anonymous"; ExceptionLogging ex = new ExceptionLogging() { DateTime = System.DateTime.Now, Identity = currentUserName, Message = e.Message, StackTrace = e.StackTrace }; try { using (FreeMarketEntities db = new FreeMarketEntities()) { db.ExceptionLoggings.Add(ex); db.SaveChanges(); } } catch { // Could not log error ex.ExceptionNumber = 999; } finally { if ((ConfigurationManager.AppSettings["notifyDeveloperOfExceptions"]) == "true") { await NotifyDeveloperAsync(ex); } } }
public static List <CashCustomer> GetCustomers(string customerCriteria) { List <CashCustomer> customers = new List <CashCustomer>(); using (FreeMarketEntities db = new FreeMarketEntities()) { customers = db.FilterCashCustomers(customerCriteria) .Select(c => new CashCustomer { DeliveryAddress = c.DeliveryAddress, Email = c.Email, Id = (int)c.Id, Name = c.Name, PhoneNumber = c.PhoneNumber }) .ToList(); } if (customers == null) { return(new List <CashCustomer>()); } return(customers); }
public static List <PriceHistory> GetAllHistories() { using (FreeMarketEntities db = new FreeMarketEntities()) { List <PriceHistory> result = db.GetPriceHistories() .Select(c => new PriceHistory { Date = c.Date, Description = c.Description, NewPrice = c.NewPrice, PriceID = c.PriceID, OldPrice = c.OldPrice, SupplierName = c.SupplierName, SupplierNumber = c.SupplierNumber, ProductNumber = c.ProductNumber, Type = c.Type }).ToList(); if (result == null) { result = new List <PriceHistory>(); } return(result); } }
public static void CreateNewExternalWebsite(ExternalWebsite website) { try { website.DateAdded = DateTime.Now; website.Department = int.Parse(website.SelectedDepartment); if (website.Url.StartsWith("http://") || website.Url.StartsWith("https://")) { } else { website.Url = website.Url.Insert(0, "http://"); } } catch { return; } using (FreeMarketEntities db = new FreeMarketEntities()) { db.ExternalWebsites.Add(website); db.SaveChanges(); } }
public static List <ExternalWebsite> GetAllWebsites() { using (FreeMarketEntities db = new FreeMarketEntities()) { List <ExternalWebsite> allWebsites = db.ExternalWebsites.ToList(); if (allWebsites != null && allWebsites.Count > 0) { foreach (ExternalWebsite website in allWebsites) { int imageNumber = db.ExternalWebsitePictures .Where(c => c.WebsiteNumber == website.LinkId && c.Dimensions == PictureSize.Medium.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); int imageNumberSecondary = db.ExternalWebsitePictures .Where(c => c.WebsiteNumber == website.LinkId && c.Dimensions == PictureSize.Medium.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); website.MainImageNumber = imageNumber; website.AdditionalImageNumber = imageNumberSecondary; } return(allWebsites); } else { return(new List <ExternalWebsite>()); } } }
public static FreeMarketResult AddAddress(string userId, string addressName, string addressLine1, string addressLine2, string addressLine3, string addressLine4, string addressSuburb, string addressCity, string addressPostalCode) { using (FreeMarketEntities db = new FreeMarketEntities()) { CustomerAddress address = new CustomerAddress() { CustomerNumber = userId, AddressName = addressName, AddressLine1 = addressLine1, AddressLine2 = addressLine2, AddressLine3 = addressLine3, AddressLine4 = addressLine4, AddressCity = addressCity, AddressPostalCode = addressPostalCode, AddressSuburb = addressSuburb }; db.CustomerAddresses.Add(address); db.SaveChanges(); AuditUser.LogAudit(5, string.Format("Address name: {0}", addressName), userId); } return(FreeMarketResult.Success); }
public void InitializeActivatedProducts() { ActivatedProducts = new ProductCollection(); using (FreeMarketEntities db = new FreeMarketEntities()) { ProductCollection products = new ProductCollection(); products = ProductCollection.GetAllProducts(); if (products == null) { return; } foreach (Product item in products.Products) { if (db.ProductCustodians.Any(c => c.ProductNumber == item.ProductNumber && c.SupplierNumber == item.SupplierNumber && c.CustodianNumber == CustodianNumber && c.Active == true)) { item.CustodianActivated = true; ActivatedProducts.Products.Add(item); } else { item.CustodianActivated = false; ActivatedProducts.Products.Add(item); } } } }
public static FreeMarketResult UpdateAddress(string userId, string addressName, string addressLine1, string addressLine2, string addressLine3, string addressLine4, string addressSuburb, string addressCity, string addressPostalCode) { using (FreeMarketEntities db = new FreeMarketEntities()) { CustomerAddress address = db.CustomerAddresses .Where(c => c.CustomerNumber == userId && c.AddressName == addressName) .FirstOrDefault(); if (address == null) { return(FreeMarketResult.Failure); } address.AddressLine1 = addressLine1; address.AddressLine2 = addressLine2; address.AddressLine3 = addressLine3; address.AddressLine4 = addressLine4; address.AddressCity = addressCity; address.AddressPostalCode = addressPostalCode; address.AddressSuburb = addressSuburb; db.Entry(address).State = EntityState.Modified; db.SaveChanges(); AuditUser.LogAudit(5, string.Format("Address name: {0}", addressName), userId); } return(FreeMarketResult.Success); }
public static ProductCollection SetAllProductDataDistinct(List <GetAllProductsDistinct_Result> allProducts) { ProductCollection collection = new ProductCollection(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (allProducts != null && allProducts.Count > 0) { foreach (GetAllProductsDistinct_Result product in allProducts) { Product prodTemp = Product.GetShallowProduct(product.ProductNumber, product.SupplierNumber); prodTemp.MinPrice = product.minPrice; prodTemp.MaxPrice = product.maxPrice; PopularProduct pp = db.PopularProducts.Where(c => c.ProductNumber == prodTemp.ProductNumber && c.SupplierNumber == prodTemp.SupplierNumber).FirstOrDefault(); if (pp != null) { prodTemp.NumberSold = pp.NumberSold ?? 0; } if (prodTemp != null) { collection.Products.Add(prodTemp); } } } return(collection); } }
public FreeMarketObject RemoveItem(int itemNumber, int productNumber, int supplierNumber, int sizeType, string userId = null) { // If the item is in the database FreeMarketResult resultDatabase = RemoveItemFromDatabase(itemNumber, userId); // Remove the item from the Session as well FreeMarketResult resultSession = RemoveItemFromSession(productNumber, supplierNumber, sizeType); if (resultDatabase == FreeMarketResult.Success && resultSession == FreeMarketResult.Success) { Product product = new Product(); using (FreeMarketEntities db = new FreeMarketEntities()) { product = db.Products.Find(itemNumber); } // Keep the OrderTotal in sync UpdateTotal(); return(new FreeMarketObject { Result = FreeMarketResult.Success, Argument = product }); } else { UpdateTotal(); return(new FreeMarketObject { Result = FreeMarketResult.Failure, Argument = null }); } }
public static Department GetDepartment(int Id) { Department model = new Department(); using (FreeMarketEntities db = new FreeMarketEntities()) { model = db.Departments.Find(Id); model.MainImageNumber = db.DepartmentPictures .Where(c => c.DepartmentNumber == model.DepartmentNumber && c.Dimensions == PictureSize.Medium.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); model.SecondaryImageNumber = db.DepartmentPictures .Where(c => c.DepartmentNumber == model.DepartmentNumber && c.Dimensions == PictureSize.Large.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); model.ItemsInDepartment = db.Products .Where(c => c.DepartmentNumber == model.DepartmentNumber) .Count(); } if (model == null) { model = new Department(); } return(model); }
private FreeMarketResult RemoveItemFromDatabase(int itemNumber, string userId = null) { FreeMarketResult result = FreeMarketResult.NoResult; if (itemNumber != 0) { using (FreeMarketEntities db = new FreeMarketEntities()) { OrderDetail item = db.OrderDetails.Find(itemNumber); if (item != null) { FreeStock(item.ProductNumber, item.SupplierNumber, (int)item.CustodianNumber, item.Quantity, item.SizeType); db.OrderDetails.Remove(item); db.SaveChanges(); AuditUser.LogAudit(8, string.Format("Order number: {0}", Order.OrderNumber), userId); result = FreeMarketResult.Success; } else { result = FreeMarketResult.Failure; } } } else { result = FreeMarketResult.Success; } return(result); }
public AspNetUserCustomer(string customerNumber, bool displayOnly) { User = new AspNetUser(); CommunicationOptions = new List <SelectListItem>(); using (FreeMarketEntities db = new FreeMarketEntities()) { User = db.AspNetUsers.Find(customerNumber); if (User == null) { User = new AspNetUser(); } CommunicationOptions = db.PreferredCommunicationMethods.Select (c => new SelectListItem { Text = c.CommunicationMethod, Value = c.CommunicationMethod }).ToList(); SelectedCommunicationOption = User.PreferredCommunicationMethod; DisplayOnly = displayOnly; } }
public void Save(string userId = null) { if (Order.OrderNumber == 0) { using (FreeMarketEntities db = new FreeMarketEntities()) { db.OrderHeaders.Add(Order); db.SaveChanges(); } } // Compare the Session cart to the database cart and resolve differences Compare(); // Re-initialize the Body Body = CartBody.GetDetailsForShoppingCart(Order.OrderNumber); // Keep the total order value in sync UpdateTotal(); // Save the Order total using (FreeMarketEntities db = new FreeMarketEntities()) { db.Entry(Order).State = EntityState.Modified; db.SaveChanges(); } AuditUser.LogAudit(6, string.Format("Order number: {0}", Order.OrderNumber), userId); }
public static SiteConfiguration GetSpecificSiteConfig(int id) { using (FreeMarketEntities db = new FreeMarketEntities()) { return(db.SiteConfigurations.Find(id)); } }
public void Merge(string userId, CartBody tempBody) { if (Order.OrderStatus != "Locked") { using (FreeMarketEntities db = new FreeMarketEntities()) { // Compare the session body with the database foreach (OrderDetail item in tempBody.OrderDetails) { OrderDetail existingItem = Body.OrderDetails .Where(c => c.ProductNumber == item.ProductNumber && c.SupplierNumber == item.SupplierNumber && c.SizeType == item.SizeType) .FirstOrDefault(); // If the item does not exist, add it if (existingItem == null) { Body.OrderDetails.Add(item); } // Otherwise update the quantity only else { Body.OrderDetails.Where(c => c.ProductNumber == item.ProductNumber && c.SupplierNumber == item.SupplierNumber && c.SizeType == item.SizeType) .FirstOrDefault() .Quantity += item.Quantity; } } } UpdateTotal(); } }
public static CashOrderViewModel CreateNewOrder(int id = 0) { CashOrderViewModel model = new CashOrderViewModel(); model.Order = new CashOrder(); using (FreeMarketEntities db = new FreeMarketEntities()) { if (id != 0) { CashCustomer customer = db.CashCustomers.Find(id); if (customer != null) { model.Order.CashCustomerId = customer.Id; model.Order.CustomerDeliveryAddress = customer.DeliveryAddress; model.Order.CustomerEmail = customer.Email; model.Order.CustomerName = customer.Name; model.Order.CustomerPhone = customer.PhoneNumber; } } model.Products = ProductCollection.GetAllProducts(); model.Custodians = db.Custodians.Select (c => new SelectListItem { Text = c.CustodianName, Value = c.CustodianNumber.ToString() }).ToList(); } model.OrderDetails = new List <CashOrderDetail>(); return(model); }
public static List <AuditUser> GetAudits(string filter) { List <AuditUser> audits = new List <AuditUser>(); if (!string.IsNullOrEmpty(filter)) { using (FreeMarketEntities db = new FreeMarketEntities()) { audits = db.FilterAuditUser(filter).Select(c => new AuditUser { Action = (short)c.Action, DateTime = (DateTime)c.DateTime, Identity = c.Identity, ActionNumber = (long)c.ActionNumber, Parameters = c.Parameters, ActionDescription = c.ActionDescription }) .ToList(); } } else { audits = new List <AuditUser>(); } return(audits); }
public static List <WebsiteFunction> GetAllFunctions() { using (FreeMarketEntities db = new FreeMarketEntities()) { return(db.WebsiteFunctions.ToList()); } }
public static void SaveCourier(Courier courier) { using (FreeMarketEntities db = new FreeMarketEntities()) { db.Entry(courier).State = EntityState.Modified; db.SaveChanges(); } }
public static void SaveModel(Support support) { using (FreeMarketEntities db = new FreeMarketEntities()) { db.Entry(support).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }