private void NewDeliveryForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
//TODO провірки
ProvideOrder provideOrder = new ProvideOrder()
{
Code = CodeGenerator.GenerateCode("ProvideOrder", "po"),
Date = DateTime.Now,
TotalCost = (int)TotalPrice(),
Provide_ID = (int)ProviderComboBox.SelectedValue
};
db.ProvideOrder.Add(provideOrder);
db.SaveChanges();
provideOrder = (db.ProvideOrder as IEnumerable <ProvideOrder>)
.Where(x => x.Code.Equals(provideOrder.Code))
.First();
foreach (Delivery delivery in deliveryContain.Values)
{
// записуємо вмістиме корзини в бд
delivery.Code = CodeGenerator.GenerateCode("Delivery", "d");
delivery.ProvideOrder_ID = provideOrder.ProvideOrder_ID;
delivery.Date = DateTime.Now;
db.Delivery.Add(delivery);
db.SaveChanges();
}
//db.SaveChanges();
MessageBox.Show(totalPriceLabel.Text, "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
e.Cancel = false;
}
private void NewSalesForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (basketsContain.Count == 0)
{
MessageBox.Show("Для здійснення замовлення оберіть товар", "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information);
e.Cancel = true;
return;
}
else
{
//генеруємо продажу
Sales sales = new Sales()
{
SalesCode = CodeGenerator.GenerateCode("Sales", "sl"),
Employee_ID = employee.Employee_ID,
Customer_ID = (int)customerComboBox.SelectedValue,
Date = DateTime.Now,
Guarante = guaranteeCB.Checked,
Total = TotalPrice()
};
db.Sales.Add(sales);
db.SaveChanges();
sales = (db.Sales as IEnumerable <Sales>)
.Where(x => x.SalesCode.Equals(sales.SalesCode))
.First();
GoodsShops gs;
foreach (Basket basket in basketsContain.Values)
{
// записуємо вмістиме корзини в бд
basket.Sales_ID = sales.Sales_ID;
db.Basket.Add(basket);
gs = db.GoodsShops
.Where(x => x.GoodsShops_ID.Equals(basket.GoodsShops_ID))
.First();
// зменшити кількість товарів
db.GoodsShops.Attach(gs);
gs.Count -= basket.Count;
db.SaveChanges();
}
//db.SaveChanges();
MessageBox.Show(totalPriceLabel.Text, "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
e.Cancel = false;
}
private void EmployeeIEF_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (string.IsNullOrEmpty(phoneTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
firstNameTB.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(phoneTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
firstNameTB.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(phoneTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
phoneTB.Focus();
e.Cancel = true;
return;
}
db.SaveChanges();
e.Cancel = false;
}
e.Cancel = false;
}
private void GoodsIEF_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (string.IsNullOrEmpty(modelTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
modelTB.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(codeTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
codeTB.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(descriptionTB.Text))
{
MessageBox.Show("Please ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
descriptionTB.Focus();
e.Cancel = true;
return;
}
db.SaveChanges();
e.Cancel = false;
}
e.Cancel = false;
}
private void Add_Click(object sender, EventArgs e)
{
Repair repair = new Repair()
{
ServiceTransportation_ID = (int)STComboBox.SelectedValue,
Comment = CommentTextBox.Text,
Date = DateTime.Now
};
try
{
int serviceID = (db.ServiceTransportation as IEnumerable <ServiceTransportation>)
.Where(x => x.ServiceTransportation_ID.Equals((int)STComboBox.SelectedValue))
.Select(x => x.Service_ID)
.FirstOrDefault();
Service service = (db.Service as IEnumerable <Service>)
.Where(x => x.Service_ID.Equals(serviceID))
.FirstOrDefault();
if (!service.Status_ID.Equals(StatusComboBox.SelectedValue))
{
db.Service.Attach(service);
service.Status_ID = (int)StatusComboBox.SelectedValue;
}
db.Repair.Add(repair);
db.SaveChanges();
updateTableContent();
}
catch (Exception)// переробити
{ }
}
private void NewShipmentForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
Delivery delivery = (db.Delivery as IEnumerable <Delivery>)
.Where(x => x.Deliver_ID.Equals(DeliveryComboBox.SelectedValue))
.FirstOrDefault();
GoodsShops gs = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Shop_ID.Equals(ShopComboBox.SelectedValue ?? 0) &&
x.Good_ID.Equals(delivery.Good_ID))
.FirstOrDefault();
if (gs != null)
{
db.GoodsShops.Attach(gs);
gs.Count += delivery.Count;
}
else
{
gs = new GoodsShops()
{
Code = CodeGenerator.GenerateCode("GoodsShops", "gs"),
Good_ID = delivery.Good_ID,
Shop_ID = (int)ShopComboBox.SelectedValue,
Count = delivery.Count
};
db.GoodsShops.Add(gs);
db.SaveChanges();
gs = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Shop_ID.Equals(ShopComboBox.SelectedValue ?? 0) &&
x.Good_ID.Equals(delivery.Good_ID))
.FirstOrDefault();
}
Shipment shipment = new Shipment()
{
Deliver_ID = delivery.Deliver_ID,
GoodsShops_ID = gs.GoodsShops_ID,
Employee_ID = (int)EmployeeComboBox.SelectedValue,
Date = DateTime.Now
};
db.Shipment.Add(shipment);
db.SaveChanges();
}
e.Cancel = false;
}
private void ServiceIEF_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
db.SaveChanges();
e.Cancel = false;
}
e.Cancel = false;
}
private void createService(int status)
{
List <int> goodsShop = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Good_ID.Equals(GoodsComboBox.SelectedValue))
.Select(x => x.GoodsShops_ID)
.ToList();
int basket = (db.Basket as IEnumerable <Basket>)
.Where(x => x.Sales_ID.Equals(SalesComboBox.SelectedValue) && goodsShop.Contains(x.GoodsShops_ID))
.Select(x => x.Basket_ID)
.FirstOrDefault();
//TODO
Service service = new Service()
{
Code = CodeGenerator.GenerateCode("Service", "se"),
Breakage_ID = (int)BreakageComboBox.SelectedValue,
Status_ID = status,
Basket_ID = basket,
Date = DateTime.Now
};
db.Service.Add(service);
db.SaveChanges();
MessageBox.Show(service.Code, "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void Delete_Click(object sender, EventArgs e)
{
if (breakageBindingSource.Current != null)
{
if (MessageBox.Show("Ви впевнені ?", "Увага", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
db.Breakage.Remove(breakageBindingSource.Current as Breakage);
db.SaveChanges();
breakageBindingSource.RemoveCurrent();
}
catch (Exception exc)
{
MessageBox.Show("Дані не можливо видалити, оскільки це порушить цілісність бази даних", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private void NewServiceTransportationForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (ServiceComboBox.SelectedValue != null)
{
if (SCComboBox.SelectedValue != null)
{
ServiceTransportation serviceTransportation = new ServiceTransportation()
{
Code = CodeGenerator.GenerateCode("ServiceTransportation", "st"),
Service_ID = (int)ServiceComboBox.SelectedValue,
SC_ID = (int)SCComboBox.SelectedValue,
Date = DateTime.Now
};
Service service = db.Service
.Where(x => x.Service_ID.Equals((int)ServiceComboBox.SelectedValue))
.FirstOrDefault();
db.Service.Attach(service);
service.Status_ID = 4;//у перевезені
db.ServiceTransportation.Add(serviceTransportation);
db.SaveChanges();
}
else
{
MessageBox.Show("Оберіть сервісний центр", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
e.Cancel = true;
return;
}
}
else
{
MessageBox.Show("оберіть заявку на ремонт", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
e.Cancel = true;
return;
}
}
e.Cancel = false;
}
private void NewTransportationForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (!ShopFromComboBox.SelectedValue.Equals(ShopToComboBox.SelectedValue))
{
if (countNUD.Value < 1)
{
MessageBox.Show("Оберіть кількість", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
e.Cancel = true;
return;
}
else
{
int goodID = (int)(goodsComboBox.SelectedValue ?? 0);
int shopTo = (int)(ShopToComboBox.SelectedValue ?? 0);
GoodsShops GS_To = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Good_ID.Equals(goodID) &&
x.Shop_ID.Equals(shopTo))
.Select(x => x)
.FirstOrDefault();
if (GS_To == null)
{
GS_To = new GoodsShops()
{
Code = CodeGenerator.GenerateCode("GoodsShops", "gs"),
Good_ID = goodID,
Shop_ID = shopTo,
Count = 0
};
db.GoodsShops.Add(GS_To);
db.SaveChanges();
GS_To = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Good_ID.Equals(goodID) &&
x.Shop_ID.Equals(shopTo))
.Select(x => x)
.FirstOrDefault();
}
GoodsShops GS_From = (db.GoodsShops as IEnumerable <GoodsShops>)
.Where(x => x.Good_ID.Equals(goodID) &&
x.Shop_ID.Equals(ShopFromComboBox.SelectedValue ?? 0))
.Select(x => x)
.FirstOrDefault();
int count = (int)countNUD.Value;
Transportation transportation = new Transportation()
{
GS_from_ID = GS_From.GoodsShops_ID,
GS_in_ID = GS_To.GoodsShops_ID,
Employee_ID = employee.Employee_ID,
Date = DateTime.Now,
Count = count
};
db.Transportation.Add(transportation);
db.GoodsShops.Attach(GS_From);
GS_From.Count -= count;
db.GoodsShops.Attach(GS_To);
GS_To.Count += count;
db.SaveChanges();
//this.Close();
}
}
else
{
MessageBox.Show("Оберіть різні магазини", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
e.Cancel = true;
return;
}
}
e.Cancel = false;
}
