public static List <User> GetUsers() { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.User.ToList()); } }
public static Customer GetCustomer(string customerName) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Customer.Where(s => s.Name == customerName).FirstOrDefault()); } }
public static Category GetCategory(string categoryName) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Category.Where(s => s.Name == categoryName && s.RegistrationStatus == (byte)RegistrationStatus.Active).FirstOrDefault()); } }
public static List <Sale> GetSalesFromProduct(int productID) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Sale.Where(s => s.ProductID == productID).ToList()); } }
public static List <Sale> GetSales(DateTime dateOfSale) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Sale.Where(s => s.DateOfSale == dateOfSale).ToList()); } }
public static User GetUser(int userID) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.User.Where(s => s.ID == userID).FirstOrDefault()); } }
public static List <Customer> GetCustomers() { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Customer.Where(s => s.RegistrationStatus == (byte)RegistrationStatus.Active).ToList()); } }
public static List <Sale> GetSales() { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Sale.ToList()); } }
public static Customer GetCustomer(int customerID) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Customer.Where(a => a.ID == customerID).FirstOrDefault()); } }
public static Category GetCategoryFromProduct(Product product) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Category.Where(s => s.ID == product.CategoryID && s.RegistrationStatus == (byte)RegistrationStatus.Active).FirstOrDefault()); } }
public static List <Product> GetProducts() { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Product.ToList()); } }
public static List <Category> GetGategories() { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Category.Where(s => s.RegistrationStatus == (byte)RegistrationStatus.Active).ToList()); } }
private void btnLogin_Click(object sender, EventArgs e) { string userName = txtUserName.Text; string passWord = txtPassWord.Text; string passWordHash = Securities.CreateMD5(passWord); using (StoreManagementEntities ef = new StoreManagementEntities()) { foreach (var acc in ef.Account) { string usernameFromDB = acc.Username.Trim(); string passWordFromDB = acc.Password.Trim(); if (userName == usernameFromDB && passWordHash == passWordFromDB) { this.Hide(); FormMain frmMain = new FormMain(); frmMain.Show(); //MessageBox.Show("Login Successful.", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information); notifyIconLogin.BalloonTipIcon = ToolTipIcon.Info; notifyIconLogin.BalloonTipTitle = "Infomation"; notifyIconLogin.BalloonTipText = "Login Successful"; notifyIconLogin.ShowBalloonTip(3000); return; } } MessageBox.Show("Please, Check username and password again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static List <Sale> GetSalesBetweenSelectedDates(DateTime startDate, DateTime endDate) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Sale.Where(s => s.DateOfSale >= startDate && s.DateOfSale <= endDate).ToList()); } }
public static List <Sale> GetSalesFromCustomer(int customerID) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Sale.Where(s => s.CustomerID == customerID).ToList()); } }
public static List <Product> GetProductsFromCategory(int categoryID) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Product.Where(s => s.CategoryID == categoryID && s.RegistrationStatus == (byte)RegistrationStatus.Active).ToList()); } }
public static Product GetProduct(string productName) { using (StoreManagementEntities store = new StoreManagementEntities()) { return(store.Product.Where(s => s.Name == productName && (s.RegistrationStatus == (byte)RegistrationStatus.Active)).FirstOrDefault()); } }
public static bool CRUDSale(Sale sale, EntityState state) { using (StoreManagementEntities store = new StoreManagementEntities()) { store.Entry(sale).State = state; if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool ChangeUserPassword(User user) { using (StoreManagementEntities store = new StoreManagementEntities()) { store.Entry(user).State = EntityState.Modified; if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool DecreaseFromStock(int productID, int numberOfProducts) { using (StoreManagementEntities store = new StoreManagementEntities()) { var product = store.Product.Where(s => s.ID == productID).First(); product.Stock -= numberOfProducts; if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool CRUDProduct(Product product, EntityState state) { using (StoreManagementEntities store = new StoreManagementEntities()) { if (state == EntityState.Deleted) { product.RegistrationStatus = (byte)RegistrationStatus.Passive; } else { store.Entry(product).State = state; product.RegistrationStatus = (byte)RegistrationStatus.Active; } if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool CRUDCustomer(Customer customer, EntityState state) { using (StoreManagementEntities store = new StoreManagementEntities()) { if (state == EntityState.Deleted) { customer.RegistrationStatus = (byte)RegistrationStatus.Passive; store.Entry(customer).State = EntityState.Modified; } else { store.Entry(customer).State = state; customer.RegistrationStatus = (byte)RegistrationStatus.Active; } if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static string DrawChart(ChartData.TimeSpan time) { InitChartValue(time); string ChartData = "&chd=t:"; string ChartLabel = "&chl="; string ChartLegend = "&chdl="; using (StoreManagementEntities context = new StoreManagementEntities()) { foreach (KeyValuePair <int, int> product in TopProduct) { ChartData += product.Value + ","; ChartLabel += product.Value + "|"; string name = context.Products.Find(product.Key).ProductName; name = name.Replace(" ", "+"); if (name.Length > 20) { name = name.Substring(0, 20) + "..."; } ChartLegend += name + "|"; } } ChartData = ChartData.Remove(ChartData.Length - 1); ChartLabel = ChartLabel.Remove(ChartLabel.Length - 1); ChartLegend = ChartLegend.Remove(ChartLegend.Length - 1); return(BaseChartURL + ChartType + ChartColorFill + ChartColor + ChartSize + ChartData + ChartLabel + ChartLegend); }
public ProductRepository(StoreManagementEntities Dbcontext) : base(Dbcontext) { }
public SaleRepository(StoreManagementEntities Dbcontext) : base(Dbcontext) { }
public Repository(StoreManagementEntities context) { Dbcontext = context; dbSet = Dbcontext.Set <T>(); }
public CustomerRepository(StoreManagementEntities Dbcontext) : base(Dbcontext) { }
public ProductRepository() { _Context = new StoreManagementEntities(); }
public UserRepository() { _Context = new StoreManagementEntities(); }
public CustomerRepository(StoreManagementEntities DbContext) { this.DbContext = DbContext; }