private void BtnEdit_Click(object sender, EventArgs e)
{
WareHouseSupplier Sup = new WareHouseSupplier();
WareHouseItem wareHouseItem = new WareHouseItem();
var ItemInfo = db.Items.Where(S => S.Name == comboBox1.Text).FirstOrDefault();
var supplierInfo = db.Suppliers.Where(S => S.Name == comboBox2.Text).FirstOrDefault();
var WareHouseInfo = db.WareHouses.Where(S => S.Name == comboBox3.Text).FirstOrDefault();
Sup = db.WareHouseSuppliers.SingleOrDefault(s => s.id == Id);
Sup.IdItem = ItemInfo.ID;
Sup.IdSupplier = supplierInfo.Id;
Sup.IdWareHouse = WareHouseInfo.Id;
wareHouseItem.IdWareHouse = WareHouseInfo.Id;
wareHouseItem.Quantity = int.Parse(TBQuantity.Text);
wareHouseItem.IdItem = ItemInfo.ID;
Sup.Quantity = int.Parse(TBQuantity.Text);
Sup.LicenseNum = int.Parse(TBPermitNUM.Text);
Sup.LicenseDate = LicenseDate.Value;
db.SaveChanges();
MessageBox.Show("Done");
this.Close();
_formPermission.ListOfSupplyPermission.DataSource = db.WareHouseSuppliers.Select(P => new { P.id, P.IdItem, P.IdSupplier, P.IdWareHouse, P.LicenseDate, P.LicenseNum, P.Quantity }).ToList();
}
private void BtnAdd_Click(object sender, EventArgs e)
{
WareHouseSupplier Sperm = new WareHouseSupplier();
//|| CBCust.SelectedItem == null || CBItems.SelectedItem == null || CBStore.SelectedItem == null || CBSupplier.SelectedItem == null
WareHouseItem store = new WareHouseItem();
var itemInfo = ENT.Items.Where(r => r.Name == (string)comboBox1.SelectedItem).SingleOrDefault();
var supplierInfo = ENT.Suppliers.Where(r => r.Name == (string)comboBox2.SelectedItem).SingleOrDefault();
var storeInfo = ENT.WareHouses.Where(r => r.Name == (string)comboBox3.SelectedItem).SingleOrDefault();
try
{
if (string.IsNullOrWhiteSpace(TBQuantity.Text) || string.IsNullOrWhiteSpace(TBPermitNUM.Text))
{
MessageBox.Show("Please Complete empty Field");
}
else if (Convert.ToInt32(TBQuantity.Text) > itemInfo.Quantity)
{
MessageBox.Show("this Quantity Greater than item Quantity");
}
else
{
Sperm.IdItem = itemInfo.ID;
Sperm.IdSupplier = supplierInfo.Id;
Sperm.IdWareHouse = storeInfo.Id;
store.IdItem = itemInfo.ID;
store.IdWareHouse = storeInfo.Id;
Sperm.LicenseDate = LicenseDate.Value; //permission date
store.Quantity = Convert.ToInt32(TBQuantity.Text);
Sperm.Quantity = Convert.ToInt32(TBQuantity.Text);
var quantity = itemInfo.Quantity - Convert.ToInt32(TBQuantity.Text);
itemInfo.Quantity = quantity;
Sperm.LicenseNum = Convert.ToInt32(TBPermitNUM.Text);
ENT.WareHouseSuppliers.Add(Sperm);
ENT.WareHouseItems.Add(store);
ENT.SaveChanges();
MessageBox.Show("Done");
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
TBQuantity.Text = string.Empty;
TBPermitNUM.Text = string.Empty;
ListOfSupplyPermission.DataSource = ENT.WareHouseSuppliers.Select(P => new { P.id, P.IdItem, P.IdSupplier, P.IdWareHouse, P.LicenseDate, P.LicenseNum, P.Quantity }).ToList();
}
}
catch (Exception)
{
MessageBox.Show("Please Invalid Inputs");
}
}
private void EditSupPermission_Load(object sender, EventArgs e)
{
WareHouseSupplier item = new WareHouseSupplier();
item = db.WareHouseSuppliers.SingleOrDefault(s => s.id == Id);
comboBox1.Text = item.Item.Name;
comboBox2.Text = item.Supplier.Name.ToString();
comboBox3.Text = item.WareHouse.Name;
TBQuantity.Text = item.Quantity.ToString();
TBPermitNUM.Text = item.LicenseNum.ToString();
LicenseDate.Value = item.LicenseDate.Value;
}
private void button1_Click(object sender, EventArgs e)
{
var itemInfo = db.Items.Where(r => r.Name == (string)CBItems.SelectedItem).SingleOrDefault();
var supplierInfo = db.Suppliers.Where(r => r.Name == (string)CBSupplier.SelectedItem).SingleOrDefault();
var storeInfoFrom = db.WareHouses.Where(r => r.Name == (string)CBFrom.SelectedItem).SingleOrDefault();
var storeInfoTo = db.WareHouses.Where(r => r.Name == (string)CBTo.SelectedItem).SingleOrDefault();
WareHouseItem Item = new WareHouseItem();
WareHouseSupplier Supplier = new WareHouseSupplier();
Item items = new Item();
var wareHouseItems = db.WareHouseItems.Where(r => r.IdWareHouse == storeInfoFrom.Id).SingleOrDefault();
var wareHouseSupplier = db.WareHouseSuppliers.Where(r => r.IdWareHouse == storeInfoFrom.Id).SingleOrDefault();
// items transfare
wareHouseSupplier.IdItem = itemInfo.ID;
wareHouseItems.IdItem = itemInfo.ID;
// Quantity Transfar
wareHouseItems.Quantity = Convert.ToInt32(TBQuntity.Text);
wareHouseSupplier.Quantity = Convert.ToInt32(TBQuntity.Text);
// supplier Transfare
wareHouseSupplier.IdSupplier = supplierInfo.Id;
// date
wareHouseSupplier.LicenseDate = date.Value;
// EXP
items.EXP = Convert.ToInt32(TBEXP.Text);
// store transfare
wareHouseSupplier.IdWareHouse = storeInfoTo.Id;
wareHouseItems.IdWareHouse = storeInfoTo.Id;
db.SaveChanges();
MessageBox.Show("Done");
}
