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;
}
