public void SalarySet()
{
try {
if (textBox.Text == "")
textBox.Text = "0";
if (textBox1.Text == "")
textBox1.Text = "0";
double time = 0;
double salarys = 0;
double sum = 0;
UserContext db = new UserContext();
List<WorkingTime> WorkTime = db.WorkingTimes.Where(x => x.TimeStart > From.SelectedDate).Where(x => x.TimeEnd < To.SelectedDate).Where(x => x.EmployeesId == EmployeId).ToList();
foreach (WorkingTime fo in WorkTime)
{
time += fo.time;
}
time = time / 60.0;
salarys += time * Convert.ToDouble(textBox.Text);
List<Check> lstcheck = db.Checks.Where(x => x.Date > From.SelectedDate).Where(x => x.Date < To.SelectedDate).Where(x => x.EmployeesId == EmployeId).ToList();
foreach (Check ch in lstcheck)
{
sum += ch.Sum;
}
salarys += sum * Convert.ToDouble(textBox1.Text) / 100.0;
label_salary.Content = Convert.ToString(salarys);
if (textBox.Text == "0")
textBox.Text = "";
if (textBox1.Text == "0")
textBox1.Text = "";
}
catch
{
MessageBox.Show("Error");
}
}
public OrderEdit()
{
InitializeComponent();
UserContext db = new UserContext();
var q = db.Goodss.Include("Weapon");
dataGrid.ItemsSource = GoodsViewMode(q.Include("Accessories").ToList());
GoodsGrid.Visibility = Visibility.Hidden;
CountPriceGrid.Visibility = Visibility.Hidden;
}
public WorkerMain()
{
UserContext db = new UserContext();
InitializeComponent();
//Запоняем таблицу для нового чека
dataGridCheck.ItemsSource = checks;
//Запоняем таблицу для покупателей
dataGridCustomer.ItemsSource = db.Customers.ToList();
//Запоняем таблицу для Товаров
var s = db.Goodss.Include("Weapon");
dataGridGoods.ItemsSource = GoodsViewMode(s.Include("Accessories").ToList());
AddGoodsGrid.Visibility = Visibility.Hidden;
}
public DeliveryEdit()
{
InitializeComponent();
UserContext db = new UserContext();
var q = db.Goodss.Include("Weapon");
dataGrid.ItemsSource = GoodsViewMode(q.Include("Accessories").ToList());
GoodsGrid.Visibility = Visibility.Hidden;
CountPriceGrid.Visibility = Visibility.Hidden;
List<string> combobox = new List<string>() { "Наличная", "Безналичная", "Неоплачена" };
comboBox_TypePayment.ItemsSource = combobox;
}
private void SubmitBorder_MouseDown(object sender, MouseButtonEventArgs e)
{
try {
Customer cust = new Customer();
cust.FullName = textBox_surname.Text + " " + textBox_name.Text + " " + textBox_fathername.Text;
cust.PassportNumber = textBox_Passport.Text;
cust.PermitWeapon = textBox_Weapon.Text;
cust.ValidFrom = Convert.ToDateTime(textBox_validfrom.Text);
cust.ValidTo = Convert.ToDateTime(textBox_validto.Text);
UserContext db = new UserContext();
db.Customers.Add(cust);
db.SaveChanges();
this.Close();
}
catch
{
MessageBox.Show("Error");
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
UserContext db = new UserContext();
if (delinfo == null)
{
OrderViewModel edit = dataGridGoods.SelectedItem as OrderViewModel;
OrderViewModel f = lst.FirstOrDefault(x => x == edit);
f.Price = Convert.ToDouble(textBLock_Price.Text);
f.Count = Convert.ToInt32(textBox_Count.Text);
dataGridGoods.ItemsSource = null;
}
else
{
delinfo.Price = Convert.ToDouble(textBLock_Price.Text);
delinfo.Count = Convert.ToInt32(textBox_Count.Text);
lst.Add(delinfo);
dataGridGoods.ItemsSource = null;
delinfo = null;
}
db.SaveChanges();
button1_Click(null, null);
}
private void button2_Click(object sender, RoutedEventArgs e)
{
try {
if (textBox_Count.Text != "" && textBox_Count.Text != "0" && textBox_PurchasePrice.Text != "" && textBox_PurchasePrice.Text != "0" && textBox_SellPrice.Text != "" && textBox_SellPrice.Text != "0")
{
UserContext db = new UserContext();
if (delinfo == null)
{
DeliveryViewModel edit = dataGridGoods.SelectedItem as DeliveryViewModel;
DeliveryViewModel f = lst.FirstOrDefault(x => x == edit);
db.Goodss.FirstOrDefault(x => x.Id == f.GoodsId).Balance -= f.Count;
f.Price = Convert.ToDouble(textBox_PurchasePrice.Text);
f.Count = Convert.ToInt32(textBox_Count.Text);
db.Goodss.Find(edit.GoodsId).SellPrice = Convert.ToDouble(textBox_SellPrice.Text);
db.Goodss.Find(f.GoodsId).PricePurchase = Convert.ToDouble(textBox_PurchasePrice.Text);
db.Goodss.FirstOrDefault(x => x.Id == f.GoodsId).Balance += f.Count;
dataGridGoods.ItemsSource = null;
}
else
{
delinfo.Price = Convert.ToDouble(textBox_PurchasePrice.Text);
delinfo.Count = Convert.ToInt32(textBox_Count.Text);
db.Goodss.Find(delinfo.GoodsId).SellPrice = Convert.ToDouble(textBox_SellPrice.Text);
db.Goodss.Find(delinfo.GoodsId).PricePurchase = Convert.ToDouble(textBox_PurchasePrice.Text);
lst.Add(delinfo);
db.Goodss.FirstOrDefault(x => x.Id == delinfo.GoodsId).Balance += delinfo.Count;
dataGridGoods.ItemsSource = null;
delinfo = null;
}
db.SaveChanges();
button1_Click(null, null);
}
else
{
MessageBox.Show("Неправильный ввод");
}
}
catch
{
MessageBox.Show("Error");
}
}
private void textBox_TextChanged(object sender, TextChangedEventArgs e)
{
UserContext db = new UserContext();
var s = db.Goodss.Include("Weapon");
List<GoodsViewModel> list = GoodsViewMode(s.Include("Accessories").ToList());
dataGrid.ItemsSource = list.Where(x => x.Name.ToUpper().Contains(textBox.Text.ToUpper()));
}
private void Lol_Loaded(object sender, RoutedEventArgs e)
{
UserContext db = new UserContext();
if (IdDelivery != -1)
{
DeliveryNote deliver = db.DeliveryNotes.FirstOrDefault(x => x.Id == IdDelivery);
label4.Content = deliver.Employees.Surname + " " + deliver.Employees.Name;
foreach (DeliveryInfo s in deliver.DeliveryInfos)
{
lst.Add(new DeliveryViewModel(s, s.Id));
}
}
else
{
Employee emp = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
label4.Content = emp.Surname + " " + emp.Name;
}
if (lst.Count != 0)
{
i = lst[lst.Count - 1].Id + 1;
}
dataGridGoods.ItemsSource = lst;
SetSumma();
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (dataGridGoods.SelectedItem != null)
{
MainGrid.IsEnabled = false;
UserContext db = new UserContext();
CountPriceGrid.Visibility = Visibility.Visible;
DeliveryViewModel edit = dataGridGoods.SelectedItem as DeliveryViewModel;
textBox_Count.Text = Convert.ToString(edit.Count);
textBox_PurchasePrice.Text = Convert.ToString(edit.Price);
textBox_SellPrice.Text = Convert.ToString(db.Goodss.Find(edit.GoodsId).SellPrice);
}
else
{
MessageBox.Show("Вы ничего не выбрали!", "Ошибка");
}
SetSumma();
}
private void button7_Click(object sender, RoutedEventArgs e)
{
try
{
UserContext db = new UserContext();
if (IdDelivery == -1)
{
Order delnew = new Order();
delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
delnew.Date = DateTime.Now;
if (checkBox.IsChecked == true)
delnew.Status = true;
else
delnew.Status = false;
foreach (OrderViewModel delvm in lst)
{
OrderInfo delinfo = new OrderInfo();
delinfo.Count = delvm.Count;
delinfo.Goods = db.Goodss.Find(delvm.GoodsId);
delnew.OrderInfos.Add(delinfo);
}
db.Orders.Add(delnew);
delnew.SavePDF();
}
else
{
Order delnew = db.Orders.Include("OrderInfos").FirstOrDefault(x => x.Id == IdDelivery);
delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
delnew.OrderInfos.Clear();
delnew.Date = DateTime.Now;
if (checkBox.IsChecked == true)
delnew.Status = true;
else
delnew.Status = false;
delnew.OrderInfos.Clear();
foreach (OrderViewModel delvm in lst)
{
OrderInfo delinfo = new OrderInfo();
delinfo.Count = delvm.Count;
delinfo.Goods = db.Goodss.Find(delvm.GoodsId);
delnew.OrderInfos.Add(delinfo);
}
delnew.SavePDF();
}
foreach (OrderInfo s in db.OrderInfos.ToList())
{
if (s.GoodsId == null)
db.OrderInfos.Remove(s);
}
db.SaveChanges();
Close();
}
catch
{
MessageBox.Show("Error");
}
}
private void button6_Click(object sender, RoutedEventArgs e)
{
if (dataGridGoods.SelectedItem !=null)
{
UserContext db = new UserContext();
DeliveryViewModel del = dataGridGoods.SelectedItem as DeliveryViewModel;
db.Goodss.FirstOrDefault(x => x.Id == del.GoodsId).Balance -= del.Count;
lst.Remove(lst.FirstOrDefault(x => x == del));
dataGridGoods.ItemsSource = null;
dataGridGoods.ItemsSource = lst;
}
else
{
MessageBox.Show("Вы ничего не выбрали!", "Ошибка");
}
SetSumma();
}
private void button3_Click(object sender, RoutedEventArgs e)
{
if (dataGrid.SelectedItem != null)
{
delinfo = new DeliveryViewModel();
UserContext db = new UserContext();
var q = db.Goodss.Include("Weapon");
GoodsViewModel per = dataGrid.SelectedItem as GoodsViewModel;
Goodss f = q.Include("Accessories").FirstOrDefault(x => x.Id == per.Id);
delinfo.GoodsId = f.Id;
delinfo.Id = i;
if (f.Accessories == null)
{
delinfo.Name = f.Weapon.CodeName;
}
else
{
delinfo.Name = f.Accessories.Name;
}
CountPriceGrid.Visibility = Visibility.Visible;
}
else
{
MessageBox.Show("Вы ничего не выбрали!", "Ошибка");
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
UserContext db = new UserContext();
if (IdDelivery != -1)
{
Order deliver = db.Orders.Include("OrderInfos").FirstOrDefault(x => x.Id == IdDelivery);
label4.Content = deliver.Employees.Surname + " " + deliver.Employees.Name;
foreach (OrderInfo s in deliver.OrderInfos)
{
lst.Add(new OrderViewModel(s, s.Id));
}
}
else
{
Employee emp = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
label4.Content = emp.Surname + " " + emp.Name;
}
if (lst.Count != 0)
{
i = lst[lst.Count - 1].Id + 1;
}
dataGridGoods.ItemsSource = lst;
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (dataGridGoods.SelectedItem != null)
{
MainGrid.IsEnabled = false;
UserContext db = new UserContext();
CountPriceGrid.Visibility = Visibility.Visible;
OrderViewModel edit = dataGridGoods.SelectedItem as OrderViewModel;
textBox_Count.Text = Convert.ToString(edit.Count);
textBLock_Price.Text = Convert.ToString(edit.Price);
}
else
{
MessageBox.Show("Вы ничего не выбрали!", "Ошибка");
}
}
void AddCustomer_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
UserContext db = new UserContext();
dataGridCustomer.ItemsSource = db.Customers.ToList();
}
private void button7_Click(object sender, RoutedEventArgs e)
{
try {
UserContext db = new UserContext();
if (IdDelivery == -1)
{
DeliveryNote delnew = new DeliveryNote();
delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
delnew.TypePayment = comboBox_TypePayment.SelectedItem as string;
delnew.Sum = 0;
delnew.Date = DateTime.Now;
foreach (DeliveryViewModel delvm in lst)
{
DeliveryInfo delinfo = new DeliveryInfo();
delinfo.Count = delvm.Count;
delinfo.Price = delvm.Price;
delinfo.Goods = db.Goodss.Find(delvm.GoodsId);
delnew.Sum += delvm.Summa;
delnew.DeliveryInfos.Add(delinfo);
}
delnew.SavePDF();
db.DeliveryNotes.Add(delnew);
}
else
{
DeliveryNote delnew = db.DeliveryNotes.FirstOrDefault(x => x.Id == IdDelivery);
delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId);
delnew.TypePayment = comboBox_TypePayment.SelectedItem as string;
delnew.Sum = 0;
delnew.Date = DateTime.Now;
delnew.DeliveryInfos.Clear();
foreach (DeliveryViewModel delvm in lst)
{
DeliveryInfo delinfo = new DeliveryInfo();
delinfo.Count = delvm.Count;
delinfo.Price = delvm.Price;
delinfo.Goods = db.Goodss.Find(delvm.GoodsId);
delnew.Sum += delvm.Summa;
delnew.DeliveryInfos.Add(delinfo);
}
delnew.SavePDF();
}
db.SaveChanges();
Close();
}
catch
{
MessageBox.Show("Error");
}
}
private void button6_Click(object sender, RoutedEventArgs e)
{
if (dataGridGoods.SelectedItem != null)
{
UserContext db = new UserContext();
OrderViewModel del = dataGridGoods.SelectedItem as OrderViewModel;
lst.Remove(lst.FirstOrDefault(x => x == del));
dataGridGoods.ItemsSource = null;
dataGridGoods.ItemsSource = lst;
}
else
{
MessageBox.Show("Вы ничего не выбрали!", "Ошибка");
}
}