public void DeleteClick(object obj)
{
using (var db = new MeiMeiContext())
{
var delete = (from b in db.Shedules
where b.CustomerName == Customer && b.ServiceName == Service && b.EmployeeTable.FIO == Employee && b.Time == b.Time && b.Size == b.Size && b.Data == b.Data
select b).FirstOrDefault();
var deleteHistory = (from b in db.EmployeeHistories
where b.ServiceName == Service
select b).FirstOrDefault();
var deletehistoryCustomer = (from b in db.Histories
where b.ServiceName == Service
select b).FirstOrDefault();
db.Shedules.Remove(delete);
db.SaveChanges();
db.EmployeeHistories.Remove(deleteHistory);
db.SaveChanges();
db.Histories.Remove(deletehistoryCustomer);
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.RemovedSuccessfully_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
ScheduleVM.Instance.FindeShedule(ShedulePage.Instance.gridShedule);
}
public void EditSheduleCommandClick(object obj)
{
if (SelectedFirstTime != null && SelectedSecondTime != null)
{
using (var db = new MeiMeiContext())
{
var shedules = (from b in db.Shedules
where b.Id == shedule.Id
select b).FirstOrDefault();
shedules.CustomerName = ClientName;
shedules.Time = SelectedFirstTime.Id.ToString();
shedules.Size = SelectedSecondTime.Id.ToString();
shedules.ServiceName = Service;
shedules.ServicePrice = Price;
shedules.Data = MyDate;
shedules.EmployeeTable.FIO = Employye;
shedules.Room = shedule.Room;
db.SaveChanges();
var history = (from b in db.Histories
where b.Id == shedules.Id && b.Customer.FIO == shedules.CustomerName
select b).FirstOrDefault();
history.ServiceName = Service;
history.ServiceCost = Price;
db.SaveChanges();
}
ScheduleVM.Instance.FindeShedule(ShedulePage.Instance.gridShedule);
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void RemoveCommand(object obj)
{
if (SelectedEmployee != null)
{
using (var db = new MeiMeiContext())
{
while (db.EmployeeHistories.Count() != null)
{
var history = (from b in db.EmployeeHistories
join ba in db.EmployeeTables on b.EmployeeTableId equals ba.Id
where b.EmployeeTableId == SelectedEmployee.Id
select b).FirstOrDefault();
if (history != null)
{
db.EmployeeHistories.Remove(history);
db.SaveChanges();
}
else
{
break;
}
}
while (db.Shedules.Count() != null)
{
var shedule = (from b in db.Shedules
join ba in db.EmployeeTables on b.EmployeeTableId equals ba.Id
where b.EmployeeTableId == SelectedEmployee.Id
select b).FirstOrDefault();
if (shedule != null)
{
db.Shedules.Remove(shedule);
db.SaveChanges();
}
else
{
break;
}
}
var employee = (from b in db.EmployeeTables
where b.FIO == SelectedEmployee.FIO && b.Id == SelectedEmployee.Id
select b).FirstOrDefault();
db.EmployeeTables.Remove(employee);
db.SaveChanges();
OnPropertyChanged("EmployeeFIOCollection");
}
}
else
{
MessageBox.Show(Properties.Resources.FirstSelectObject_message, "", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
public void SaveClick(object obj)
{
if (Fio != string.Empty && Birthday != string.Empty && Contacts != string.Empty && Post != string.Empty &&
Salarity != string.Empty && PersonalData != string.Empty)
{
using (var db = new MeiMeiContext())
{
var emploeyy = (from b in db.EmployeeTables
where b.FIO == EmployeeVM.Instance.SelectedEmployee.FIO
select b).FirstOrDefault();
emploeyy.FIO = Fio;
emploeyy.Birthday = Birthday;
emploeyy.Contacts = Contacts;
emploeyy.PersonalData = PersonalData;
emploeyy.Post = Post;
emploeyy.Salary = Salarity;
emploeyy.Photo = a;
db.SaveChanges();
}
_employeeVMOwner.EmployeeFIOCollection = _employeeVMOwner.EmployeeFIOCollection;
MessageBox.Show(Properties.Resources.Сompleted_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, Properties.Resources.Attention_message, MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void AddCustomersClick(object obj)
{
//Добавление и запись в бд
if (FIO != string.Empty || Contacts != string.Empty || Birthyday != string.Empty || Notes != string.Empty)
{
using (var db = new MeiMeiContext())
{
var customer = new Customers
{
FIO = FIO,
Birthday = Birthyday,
Contakts = Contacts,
Notes = Notes,
Photo = a
};
db.Customers.Add(customer);
db.SaveChanges();
}
MessageBox.Show("Добавленно", "", MessageBoxButton.OK, MessageBoxImage.Information);
FIO = string.Empty;
Birthyday = string.Empty;
Contacts = string.Empty;
Notes = string.Empty;
_customerVMOwner.CustomersColl = _customerVMOwner.CustomersColl;
}
else
{
MessageBox.Show("Пожалуста заполните все строки", "Внимание", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public void SaveCommandClick(object obj)
{
if (Fio != string.Empty || Birthday != string.Empty || Contacts != string.Empty || Post != string.Empty || PersonalData != string.Empty)
{
using (var db = new MeiMeiContext())
{
var emploeyy = new EmployeeTable
{
FIO = Fio,
Birthday = Birthday,
Contacts = Contacts,
Post = Post,
Salary = Salarity,
PersonalData = PersonalData,
Photo = a
};
db.EmployeeTables.Add(emploeyy);
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.Сompleted_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
Fio = string.Empty;
Birthday = string.Empty;
Contacts = string.Empty;
Post = string.Empty;
PersonalData = string.Empty;
Salarity = string.Empty;
_employeeVMOwner.EmployeeFIOCollection = _employeeVMOwner.EmployeeFIOCollection;
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, Properties.Resources.Attention_message, MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void SaveClick(object obj)
{
if (FIO != string.Empty && Birthyday != string.Empty && Contacts != string.Empty && Notes != string.Empty)
{
using (var db = new MeiMeiContext())
{
var customer = (from b in db.Customers
where b.Id == CustomerVM.Instance.SelectedCustomer.Id
select b).FirstOrDefault();
customer.FIO = FIO;
customer.Birthday = Birthyday;
customer.Contakts = Contacts;
customer.Notes = Notes;
customer.Photo = a;
db.SaveChanges();
}
_customerVMOwner.CustomersColl = _customerVMOwner.CustomersColl;
MessageBox.Show(Properties.Resources.Сompleted_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, Properties.Resources.Attention_message, MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void Delete(object obj)
{
if (SelectedTypeService != null && SelectedService != null)
{
using (var db = new MeiMeiContext())
{
var delete = (from b in db.Services
where b.Id == SelectedService.Id
select b).FirstOrDefault();
db.Services.Remove(delete);
db.SaveChanges();
OnPropertyChanged("PriceCollection");
}
}
else if (SelectedTypeService != null)
{
using (var db = new MeiMeiContext())
{
for (int i = 0; i < db.Services.Count(); i++)
{
var deleteService = (from b in db.Services
where b.TypeOfServiceId == SelectedTypeService.Id
select b).FirstOrDefault();
if (deleteService != null)
{
db.Services.Remove(deleteService);
db.SaveChanges();
MessageBox.Show(Properties.Resources.RemovedSuccessfully_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
break;
}
}
var deleteType = (from b in db.TypeOfServices
where b.Id == SelectedTypeService.Id
select b).FirstOrDefault();
db.TypeOfServices.Remove(deleteType);
db.SaveChanges();
}
}
}
public void DeleteGoodClick(object obj)
{
if (SelectedGoods != null && SelectedTypeOfGoods != null)
{
using (var db = new MeiMeiContext())
{
var delete = (from b in db.Goods
where b.Id == SelectedGoods.Id
select b).FirstOrDefault();
db.Goods.Remove(delete);
db.SaveChanges();
OnPropertyChanged("GoodsColl");
}
}
else if (SelectedTypeOfGoods != null)
{
using (var db = new MeiMeiContext())
{
for (int i = 0; i < db.Goods.Count(); i++)
{
var deleteGoods = (from b in db.Goods
where b.TypeOfGoodsId == SelectedTypeOfGoods.Id
select b).FirstOrDefault();
if (deleteGoods != null)
{
db.Goods.Remove(deleteGoods);
db.SaveChanges();
}
else
{
break;
}
var deleteType = (from b in db.TypeOfGoods
where b.Id == SelectedTypeOfGoods.Id
select b).FirstOrDefault();
db.TypeOfGoods.Remove(deleteType);
db.SaveChanges();
}
}
}
}
public void AddTimesCklick(object obj)
{
if (StartFrom != string.Empty && EndFrom != string.Empty)
{
int a, b;
a = Convert.ToInt32(StartFrom);
b = Convert.ToInt32(EndFrom);
int c = 0;
for (int i = a; i < b + 1; i++)
{
for (int j = 1; j < 5; j++)
{
if (c == 0)
{
using (var db = new MeiMeiContext())
{
var time = new SheduleTime
{
Time = i + " : " + c + "0"
};
db.SheduleTimes.Add(time);
db.SaveChanges();
}
}
else
{
using (var db = new MeiMeiContext())
{
var time = new SheduleTime
{
Time = i + " : " + c
};
db.SheduleTimes.Add(time);
db.SaveChanges();
}
}
c += 15;
if (c > 45)
{
c = 0;
}
}
}
}
else
{
MessageBox.Show(Properties.Resources.StartEnterDay_message, "", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
public void RemoveCustomerClick(object obj)
{
if (SelectedCustomer != null)
{
using (var db = new MeiMeiContext())
{
while (db.Histories.Count() != null)
{
var history = (from b in db.Histories
join ba in db.Customers on b.CustomersId equals ba.Id
where b.CustomersId == SelectedCustomer.Id
select b).FirstOrDefault();
if (history != null)
{
db.Histories.Remove(history);
db.SaveChanges();
}
else
{
break;
}
}
var customer = (from b in db.Customers
where b.FIO == SelectedCustomer.FIO
select b).FirstOrDefault();
db.Customers.Remove(customer);
db.SaveChanges();
}
OnPropertyChanged("CustomersColl");
}
else
{
MessageBox.Show(Properties.Resources.FirstSelectObject_message, "", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
public void SaveKategoria(object obj)
{
using (var db = new MeiMeiContext())
{
var kategoria = (from b in db.TypeOfServices
where b.TypeService == _servis.SelectedTypeService.TypeService
select b).FirstOrDefault();
if (kategoria != null)
{
kategoria.TypeService = KategoriaServis;
}
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.Save_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
public void SaveKategoria(object obj)
{
using (var db = new MeiMeiContext())
{
var kategoria = (from b in db.TypeOfGoods
where b.TypeGoods == _good.SelectedTypeOfGoods.TypeGoods
select b).FirstOrDefault();
if (kategoria != null)
{
kategoria.TypeGoods = GoodKategoria;
}
db.SaveChanges();
OnPropertyChanged("CompColl");
}
MessageBox.Show(Properties.Resources.Save_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
public void SaveService(object obj)
{
using (var db = new MeiMeiContext())
{
var service = (from b in db.Services
where b.ServiceName == _servis.SelectedService.ServiceName && b.ServicePrice == _servis.SelectedService.ServicePrice
select b).FirstOrDefault();
if (service != null)
{
service.ServiceName = NameServis;
service.ServicePrice = CostServis;
}
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.Save_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
public void SaveService(object obj)
{
using (var db = new MeiMeiContext())
{
var good = (from b in db.Goods
where b.GoodName == _good.SelectedGoods.GoodName && b.GoodPrice == _good.SelectedGoods.GoodPrice && b.Count == _good.SelectedGoods.Count
select b).FirstOrDefault();
if (good != null)
{
good.GoodName = GoodName;
good.GoodPrice = GoodPrice;
good.Count = GoodCount;
}
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.Save_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
public void AddGoodsClick(object obj)
{
PriceGoodsCollection.Add(new Add_GoodsVM {
Name = Name, Price = Price, Count = Count
});
using (var db = new MeiMeiContext())
{
var goods = new Goods
{
GoodName = Name,
GoodPrice = Price,
Count = Count,
TypeOfGoodsId = SelectTypeOfGoods.Id
};
db.Goods.Add(goods);
db.SaveChanges();
}
}
public void AddTypeGoodsClick(object obj)
{
if (Company != string.Empty)
{
using (var db = new MeiMeiContext())
{
var typeGoods = new TypeOfGoods
{
TypeGoods = Company
};
db.TypeOfGoods.Add(typeGoods);
db.SaveChanges();
}
OnPropertyChanged("TypeOfGoodsCollection");
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message);
}
}
public void AddTypeservice(object obj)
{
if (TypeOfService != string.Empty)
{
using (var db = new MeiMeiContext())
{
var typeService = new TypeOfService
{
TypeService = TypeOfService
};
db.TypeOfServices.Add(typeService);
db.SaveChanges();
}
OnPropertyChanged("TypeServiceCollection");
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, "", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
public void RemoveClick(object obj)
{
if (SelectedColumn != null)
{
using (var db = new MeiMeiContext())
{
var sheduleColumn = (from b in db.SheduleColumns
where b.ColumnName == SelectedColumn.ColumnName
select b).FirstOrDefault();
db.SheduleColumns.Remove(sheduleColumn);
db.SaveChanges();
OnPropertyChanged("ColumnCollection");
}
}
else
{
MessageBox.Show(Properties.Resources.FirstSelectObject_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void AddColumnClick(object obj)
{
if (NewColumn != string.Empty)
{
using (var db = new MeiMeiContext())
{
var column = new SheduleColumn
{
ColumnName = NewColumn
};
db.SheduleColumns.Add(column);
db.SaveChanges();
}
MessageBox.Show(Properties.Resources.Сompleted_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
OnPropertyChanged("ColumnCollection");
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void AddServis(object obj)
{
if (NameServis != String.Empty && CostServis != String.Empty && SelectTypeOfService != null)
{
if (SelectTypeOfService != null)
{
PricesColl.Add(new AddServisVM {
NameServis = NameServis, CostServis = CostServis,
});
using (var db = new MeiMeiContext())
{
var service = new Service
{
ServiceName = NameServis,
ServicePrice = CostServis,
TypeOfServiceId = SelectTypeOfService.Id
};
db.Services.Add(service);
db.SaveChanges();
}
NameServis = String.Empty;
CostServis = String.Empty;
}
else
{
MessageBox.Show(Properties.Resources.SelectServiceType_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, Properties.Resources.Attention_message, MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
public void AddShedule(object obj)
{
int size, firstNum, secondNum;
size = SelectedSecondTime.Id - SelectedFirstTime.Id + 1;
firstNum = SelectedFirstTime.Id;
if (SelectedEmployee != null && SelectedFirstTime != null &&
SelectedSecondTime != null && SelectedThisService != null && SelectedService != null)
{
if (SelectedItem == null)
{
using (var db = new MeiMeiContext())
{
var customer = new Customers
{
FIO = Customer
};
db.Customers.Add(customer);
db.SaveChanges();
}
using (var db = new MeiMeiContext())
{
var shedule = new Shedule
{
CustomerName = Customer,
ServicePrice = SelectedThisService.ServicePrice,
ServiceName = SelectedThisService.ServiceName,
Data = MyDate.Date,
EmployeeTableId = SelectedEmployee.Id,
Time = firstNum.ToString(),
Size = size.ToString(),
Room = Room,
Column = (_shedule.ColumnNumber + 1).ToString()
};
var history = new History
{
CustomersId = (from b in db.Customers
where b.FIO == Customer
select b.Id).FirstOrDefault(),
Data = MyDate.Date.ToString(),
ServiceName = SelectedThisService.ServiceName,
ServiceCost = SelectedThisService.ServicePrice + " грн."
};
var employeeHistory = new EmployeeHistory
{
Cost = SelectedThisService.ServicePrice,
Data = MyDate.Date,
EmployeeTableId = SelectedEmployee.Id,
ServiceName = SelectedThisService.ServiceName
};
db.Shedules.Add(shedule);
db.SaveChanges();
db.Histories.Add(history);
db.SaveChanges();
db.EmployeeHistories.Add(employeeHistory);
db.SaveChanges();
}
}
else if (SelectedItem != null)
{
using (var db = new MeiMeiContext())
{
var shedule = new Shedule
{
CustomerName = SelectedItem.FIO,
ServicePrice = SelectedThisService.ServicePrice,
ServiceName = SelectedThisService.ServiceName,
Data = MyDate.Date,
EmployeeTableId = SelectedEmployee.Id,
Time = firstNum.ToString(),
Size = size.ToString(),
Room = Room,
Column = (_shedule.ColumnNumber + 1).ToString()
};
var history = new History
{
CustomersId = SelectedItem.Id,
Data = MyDate.Date.ToString(),
ServiceName = SelectedThisService.ServiceName,
ServiceCost = SelectedThisService.ServicePrice + " грн."
};
var employeeHistory = new EmployeeHistory
{
Cost = SelectedThisService.ServicePrice,
Data = MyDate.Date,
EmployeeTableId = SelectedEmployee.Id,
ServiceName = SelectedThisService.ServiceName
};
db.Shedules.Add(shedule);
db.SaveChanges();
db.Histories.Add(history);
db.SaveChanges();
db.EmployeeHistories.Add(employeeHistory);
db.SaveChanges();
}
}
MessageBox.Show(Properties.Resources.Сompleted_message, "", MessageBoxButton.OK,
MessageBoxImage.Information);
ScheduleVM.Instance.FindeShedule(ShedulePage.Instance.gridShedule);
}
else
{
MessageBox.Show(Properties.Resources.FirstFill_message, "", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void SellGoodsClick(object obj)
{
if (SelectedGoods != null)
{
int price = Convert.ToInt32(SelectedGoods.GoodPrice) * Convert.ToInt32(Count);
int newCount = Convert.ToInt32(SelectedGoods.Count) - Convert.ToInt32(Count);
using (var db = new MeiMeiContext())
{
if (SelectedCustomers != null)
{
var goodHistory = new GoodHistory
{
GoodName = SelectedGoods.GoodName,
Price = price.ToString(),
Data = DateTime.Now,
Customer = SelectedCustomers.FIO
};
db.GoodHistories.Add(goodHistory);
db.SaveChanges();
var goods = (from b in db.Goods
where
b.GoodName == GoodVM.Instance.SelectedGoods.GoodName &&
b.GoodPrice == GoodVM.Instance.SelectedGoods.GoodPrice &&
b.Count == GoodVM.Instance.SelectedGoods.Count
select b).FirstOrDefault();
if (newCount >= 0)
{
goods.Count = newCount.ToString();
db.SaveChanges();
OnPropertyChanged("GoodsColl");
OnPropertyChanged("GoodsHistoryColl");
}
else
{
MessageBox.Show("Больше продать нельзя");
}
}
else if (selectedCustomers == null)
{
using (var bd = new MeiMeiContext())
{
var customer = new Customers
{
FIO = Customer
};
bd.Customers.Add(customer);
bd.SaveChanges();
var goodHistory = new GoodHistory
{
GoodName = SelectedGoods.GoodName,
Price = price.ToString(),
Data = DateTime.Now,
Customer = Customer
};
bd.GoodHistories.Add(goodHistory);
bd.SaveChanges();
var goods = (from b in bd.Goods
where
b.GoodName == GoodVM.Instance.SelectedGoods.GoodName &&
b.GoodPrice == GoodVM.Instance.SelectedGoods.GoodPrice &&
b.Count == GoodVM.Instance.SelectedGoods.Count
select b).FirstOrDefault();
OnPropertyChanged("CustomerColl");
if (newCount >= 0)
{
goods.Count = newCount.ToString();
bd.SaveChanges();
OnPropertyChanged("GoodsColl");
OnPropertyChanged("GoodsHistoryColl");
}
else
{
MessageBox.Show("Больше продать нельзя");
}
}
}
}
}
}