private void ButtonSaveUser_OnClick(object sender, RoutedEventArgs e)
{
CheckPassAndLogin check = new CheckPassAndLogin();
CaffeDataContext db = new CaffeDataContext();
HashClass hash = new HashClass();
if (check.ChceckPassEqals(Pass1TB.Text, Pass2TB.Text) && check.ChceckPassNumeric(Pass1TB.Text) &&
check.CheckPassLength(Pass1TB.Text))
{
int IdMax = db.Users.Max(s => s.Id_user);
User u = new User()
{
Name = UserNameTB.Text,
Id_user = IdMax + 1,
Password = hash.GetHashString(Pass1TB.Text)
};
db.Users.InsertOnSubmit(u);
db.SubmitChanges();
MessageBox.Show("Zapisoano zmiany !!!");
Pass1TB.Text = "";
Pass2TB.Text = "";
UserNameTB.Text = "";
}
else
{
MessageBox.Show("Nieprawidłowe dane !");
}
}
private void ButtonAddNewProduct_OnClick(object sender, RoutedEventArgs e)
{
CaffeDataContext db = new CaffeDataContext();
int IdMax = db.Products.Max(s => s.Id_Product);
double price;
if (double.TryParse(PriceTB.Text, out price) || string.IsNullOrEmpty(ProduktNameTB.Text))
{
Product p = new Product()
{
Name = ProduktNameTB.Text,
Category = CategoryComboBox.Text,
Price = price,
Id_Product = IdMax + 1
};
db.Products.InsertOnSubmit(p);
db.SubmitChanges();
}
else
{
MessageBox.Show("Nieprawidłowe dane !!!");
}
Console.WriteLine(price);
}
public void DisplayProduct(object sender, RoutedEventArgs e)
{
ComponentFabryk fabryka = new ComponentFabryk();
UniformGridNewProduct.Children.Clear();
CaffeDataContext db = new CaffeDataContext();
string ct = ((sender as Button).Content as TextBlock).Text;
var products = db.Products.Where(s => s.Category.Equals(ct));
var bc = new BrushConverter();
foreach (var item in products)
{
TextBlock tb = fabryka.GeneraTextBlock(item.Name);
tb.Foreground = (Brush)bc.ConvertFrom("#000000");
Button b = fabryka.GenerateButton(tb);
b.Tag = item.Price;
b.Click += AddProduct;
UniformGridNewProduct.Children.Add(b);
}
Button bb = fabryka.GenerateButton("");
bb.Content = "Back";
bb.Click += DisplayCategory;
UniformGridNewProduct.Children.Add(bb);
}
private void DisplayGroupOrder()
{
CaffeDataContext db = new CaffeDataContext();
var dd =
from order in db.Orders
group order by order.Date
into g
select new GroupSUM((double)g.Sum(p => p.Sum), (DateTime)g.Key);
DataTable dt = new DataTable();
DataColumn _date = new DataColumn("Data");
DataColumn _daySum = new DataColumn("Podsumowanie dnia");
dt.Columns.Add(_date);
dt.Columns.Add(_daySum);
foreach (var item in dd)
{
DataRow dr = dt.NewRow();
DateTime data = (DateTime)item._date;
dr[0] = data.ToString("yyy-MM-dd");
dr[1] = item._sum + " PLN";
dt.Rows.Add(dr);
int a = (int)data.DayOfWeek;
}
var list = dd.ToList();
Statistic statistic = new Statistic();
predictiontb.Text = "Przwidywany zarobek następnego dnia : "
+ String.Format("{0:0.00}", statistic.GetWeightAvg(list)) + " PLN";
AVGtb.Text = "Średnia ze wszytkichdni : "
+ String.Format("{0:0.00}", statistic.GetAvg(list)) + " PLN";
GroupSUM max = statistic.GetMaxvalue(list);
MAXtb.Text = "Maksymalny zarobek : "
+ String.Format("{0:0.00}", max._sum) + " PLN dnia " + max._date.ToString("yyy-MM-dd");
GroupSUM min = statistic.GetMINvalue(list);
MINtb.Text = "Maksymalny zarobek : "
+ String.Format("{0:0.00}", min._sum) + " PLN dnia " + min._date.ToString("yyy-MM-dd");
MINtb.Text = "Mediana: "
+ String.Format("{0:0.00}", statistic.Median(list)) + " PLN";
DataOrders.ItemsSource = dt.DefaultView;
List <KeyValuePair <DateTime, double> > ll = new List <KeyValuePair <DateTime, double> >();
foreach (var item in list)
{
ll.Add(new KeyValuePair <DateTime, double>(item._date, item._sum));
}
myChart.DataContext = ll;
}
public OrderDetailWindow(OrderClass o, User u, AllOrdersWindow all)
{
InitializeComponent();
_user = u;
_orderClass = o;
db = new CaffeDataContext();
allWindow = all;
//DisplayProductList();
DisplayCategory(null, null);
DisplayProductList();
}
private void CategoryComboBox_OnLoaded()
{
CaffeDataContext db = new CaffeDataContext();
var result = db.Products.GroupBy(s => s.Category).ToList();
CategoryComboBox.Items.Clear();
foreach (var item in result)
{
ComboBoxItem cbItem = new ComboBoxItem();
cbItem.Content = item.Key;
CategoryComboBox.Items.Add(cbItem);
}
}
private void UniformGridUsers_OnLoaded()
{
CaffeDataContext db = new CaffeDataContext();
UniformGridUsers.Children.Clear();
var users = db.Users;
foreach (var item in users)
{
RadioButton rb = new RadioButton();
rb.Content = item.Name;
rb.Checked += RadiobuttonChecked;
rb.Tag = item.Id_user;
UniformGridUsers.Children.Add(rb);
}
}
private void ButtonSavePassChange_OnClick(object sender, RoutedEventArgs e)
{
CheckPassAndLogin check = new CheckPassAndLogin();
if (check.ChceckPassEqals(Pass11TB.Text, Pass22TB.Text) && check.ChceckPassNumeric(Pass11TB.Text) &&
check.CheckPassLength(Pass11TB.Text))
{
CaffeDataContext db = new CaffeDataContext();
HashClass hash = new HashClass();
User u = db.Users.FirstOrDefault(s => s.Id_user == userID);
u.Password = hash.GetHashString(Pass11TB.Text);
db.SubmitChanges();
MessageBox.Show("Zapisano zmieny !!!");
Pass11TB.Text = "";
Pass22TB.Text = "";
}
else
{
MessageBox.Show("Nieprawidłowe dane !");
}
}
public AddOrder()
{
db = new CaffeDataContext();
}