private void AddBtn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(StoreNameTB.Text) && !string.IsNullOrWhiteSpace(StoreAddressTB.Text))
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
store.Name = StoreNameTB.Text;
store.Address = StoreAddressTB.Text;
store.Manager = StoreManagerTB.Text;
db.Entry(store).State = store.Id == 0 ? EntityState.Added : EntityState.Modified;
db.SaveChanges();
}
MetroMessageBox.Show(this, "New Store has been added", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowStoreData();
store.Id = 0;
}
else
{
Button btn = (Button)sender;
if (btn.Name == "UpdateBtn")
{
MetroMessageBox.Show(this, "Please fill the data to be updated or click on a row to update it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Please fill the data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// Event handlers for the items inside each permission
/// </summary>
private void ShowImportItemsDetails(int permissionNumber)
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
PermissionItemsDGV.DataSource = (from p in db.Permissions
join p_i in db.Permission_Item on p.Id equals p_i.PermissionId
join i in db.Items on p_i.ItemCode equals i.Code
join s in db.Stakeholders on i.SupplierId equals s.Id
where p.Id == permissionNumber
select new
{
Item_Code = i.Code,
Item_Name = i.Name,
Production_Date = i.ProductionDate,
Expiration_Date = i.ExpDate,
Supplier_Name = s.Name,
p_i.Quantity
}).ToList();
PermissionItemCodeCB.DataSource = db.Items.Select(s => s.Code).ToList();
}
PermissionIdTB.Text = permission.Id.ToString();
PermissionItemCodeCB.SelectedItem = null;
PermissionItemCodeCB.SelectedText = " ------- Select Item Code ------- ";
}
private void ImportAddItemBtn_Click(object sender, EventArgs e)
{
if (PermissionItemQtyIUD.Value != 0 && PermissionItemCodeCB.Text != " ------- Select Item Code ------- ")
{
Button btn = (Button)sender;
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
permission_Item.PermissionId = Convert.ToInt32(PermissionIdTB.Text);
permission_Item.ItemCode = Convert.ToInt32(PermissionItemCodeCB.Text);
permission_Item.Quantity = Convert.ToInt32(PermissionItemQtyIUD.Value);
db.Permission_Item.AddOrUpdate(permission_Item);
db.SaveChanges();
}
string proccess = stakeholder.Id == 0 ? "Added" : "Modified";
MetroMessageBox.Show(this, $"An Item has been {proccess}", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowImportItemsDetails(permission_Item.PermissionId);
}
else
{
Button btn = (Button)sender;
if (btn.Name.Contains("Update"))
{
MetroMessageBox.Show(this, "Please fill the data to be updated or click on a row to update it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Please fill the data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// Import Permission EventHandlers
/// </summary>
private void EXportAddBtn_Click(object sender, EventArgs e)
{
if (ImportStoreIdCB.Text != " ------- Select Store ID ------- ")
{
Button btn = (Button)sender;
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
permission.StoreId = Convert.ToInt32(ExportStoreIdCB.Text);
permission.PermissionDate = ExportDateTP.Value;
permission.PermissionType = 2;
db.Permissions.AddOrUpdate(permission);
db.SaveChanges();
}
string proccess = permission.Id == 0 ? "Added" : "Modified";
MetroMessageBox.Show(this, $"A Permission has been {proccess}", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowPermissionsData();
permission.Id = 0;
}
else
{
Button btn = (Button)sender;
if (btn.Name.Contains("Update"))
{
MetroMessageBox.Show(this, "Please fill the data to be updated or click on a row to update it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Please fill the data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ItemAddBtn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(ItemNameTB.Text) && !string.IsNullOrWhiteSpace(ItemUnitTB.Text))
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
item.Name = ItemNameTB.Text;
item.Unit = ItemUnitTB.Text;
item.ProductionDate = ItemPrdTP.Value;
item.ExpDate = ItemExpTP.Value;
item.SupplierId = Convert.ToInt32(ItemSpplierIdCB.SelectedItem);
db.Entry(item).State = item.Code == 0 ? EntityState.Added : EntityState.Modified;
db.SaveChanges();
}
string proccess = item.Code == 0 ? "Added" : "Modified";
MetroMessageBox.Show(this, $"An Item has been {proccess}", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowItemData();
item.Code = 0;
}
else
{
Button btn = (Button)sender;
if (btn.Name.Contains("Update"))
{
MetroMessageBox.Show(this, "Please fill the data to be updated or click on a row to update it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Please fill the data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ShowStoreData()
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
StoreDGV.DataSource = db.Stores.Select(s => new { s.Id, s.Name, s.Address, s.Manager }).ToList();
}
StoreNameTB.Text = StoreAddressTB.Text = StoreManagerTB.Text = "";
}
private void ShowPermissionsData()
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
ImportListDGV.DataSource = db.Permissions.Include(d => d.Store).Where(p => p.PermissionType.Equals(1)).Select(p => new { Permission_Number = p.Id, Store_Name = p.Store.Name, Permission_Date = p.PermissionDate }).ToList();
ExportListDGV.DataSource = db.Permissions.Include(d => d.Store).Where(p => p.PermissionType.Equals(2)).Select(p => new { Permission_Number = p.Id, Store_Name = p.Store.Name, Permission_Date = p.PermissionDate }).ToList();
ImportStoreIdCB.DataSource = ExportStoreIdCB.DataSource = db.Stores.Select(s => s.Id).ToList();
}
ImportStoreIdCB.SelectedItem = ExportStoreIdCB.SelectedItem = null;
ImportStoreIdCB.SelectedText = ExportStoreIdCB.SelectedText = " ------- Select Store ID ------- ";
}
private void ShowStakeholdersData(int role)
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
SupplierDGV.DataSource = db.Stakeholders
.Where(s => s.Role.Equals(role))
.Select(s => new { s.Id, s.Name, s.Phone, s.E_Mail, s.LandLine, s.Fax, s.WebSite })
.ToList();
}
StakeholderNameTB.Text = SupplierPhoneTB.Text = SupplierEmailTB.Text = "";
SupplierLandLineTB.Text = SupplierFaxTB.Text = SupplierWebsiteTB.Text = "";
}
private void ShowItemData()
{
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
ItemDGV.DataSource = db.Items.Select(i => new { i.Code, i.Name, i.Unit, i.ProductionDate, i.ExpDate, i.SupplierId }).ToList();
ItemSpplierIdCB.DataSource = db.Stakeholders.Where(s => s.Role.Equals(1)).Select(s => s.Id).ToList();
ItemSpplierIdCB.SelectedItem = null;
ItemSpplierIdCB.SelectedText = " -- Select Supplier ID -- ";
}
ItemNameTB.Text = ItemCodeTB.Text = ItemUnitTB.Text = "";
}
private void StoreDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (StoreDGV.CurrentRow.Index != -1)
{
store.Id = Convert.ToInt32(StoreDGV.CurrentRow.Cells["Id"].Value);
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
store = db.Stores.Where(s => s.Id == store.Id).FirstOrDefault();
StoreNameTB.Text = store.Name;
StoreAddressTB.Text = store.Address;
StoreManagerTB.Text = store.Manager;
}
}
}
private void EXportListDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (ExportListDGV.CurrentRow.Index != -1)
{
permission.Id = Convert.ToInt32(ExportListDGV.CurrentRow.Cells["Permission_Number"].Value);
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
permission = db.Permissions.Where(p => p.Id == permission.Id).SingleOrDefault();
ExportPerIdTB.Text = permission.StoreId.ToString();
ExportDateTP.Value = permission.PermissionDate;
ExportStoreIdCB.DataSource = db.Stores.Select(s => s.Id).ToList();
ExportStoreIdCB.SelectedItem = null;
ExportStoreIdCB.SelectedText = permission.StoreId.ToString();
}
}
}
private void SupplierDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (SupplierDGV.CurrentRow.Index != -1)
{
stakeholder.Id = Convert.ToInt32(SupplierDGV.CurrentRow.Cells["Id"].Value);
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
stakeholder = db.Stakeholders.Where(s => s.Id == stakeholder.Id).FirstOrDefault();
StakeholderNameTB.Text = stakeholder.Name;
SupplierPhoneTB.Text = stakeholder.Phone;
SupplierEmailTB.Text = stakeholder.E_Mail;
SupplierLandLineTB.Text = stakeholder.LandLine;
SupplierFaxTB.Text = stakeholder.Fax;
SupplierWebsiteTB.Text = stakeholder.WebSite;
}
}
}
private void StakeholderAddBtn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(StakeholderNameTB.Text) && !string.IsNullOrWhiteSpace(SupplierPhoneTB.Text) && !string.IsNullOrWhiteSpace(SupplierEmailTB.Text))
{
Button btn = (Button)sender;
int role = btn.Name.Contains("Supplier") ? 1 : 2;
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
stakeholder.Name = StakeholderNameTB.Text;
stakeholder.Phone = SupplierPhoneTB.Text;
stakeholder.E_Mail = SupplierEmailTB.Text;
stakeholder.LandLine = SupplierLandLineTB.Text;
stakeholder.Fax = SupplierFaxTB.Text;
stakeholder.WebSite = SupplierWebsiteTB.Text;
stakeholder.Role = role;
db.Entry(stakeholder).State = stakeholder.Id == 0 ? EntityState.Added : EntityState.Modified;
db.SaveChanges();
}
string person = btn.Name.Contains("Supplier") ? "Supplier" : "Customer";
string proccess = stakeholder.Id == 0 ? "Added" : "Modified";
MetroMessageBox.Show(this, $"A {person} has been {proccess}", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowStakeholdersData(role);
stakeholder.Id = 0;
}
else
{
Button btn = (Button)sender;
if (btn.Name.Contains("Update"))
{
MetroMessageBox.Show(this, "Please fill the data to be updated or click on a row to update it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Please fill the data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ItemDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (ItemDGV.CurrentRow.Index != -1)
{
item.Code = Convert.ToInt32(ItemDGV.CurrentRow.Cells["Code"].Value);
using (WarehouseDBEntities db = new WarehouseDBEntities())
{
item = db.Items.Where(i => i.Code == item.Code).FirstOrDefault();
ItemCodeTB.Text = item.Code.ToString();
ItemCodeTB.Enabled = false;
ItemNameTB.Text = item.Name;
ItemUnitTB.Text = item.Unit;
ItemPrdTP.Value = item.ProductionDate;
ItemExpTP.Value = item.ExpDate;
ItemSpplierIdCB.DataSource = db.Stakeholders.Where(s => s.Role.Equals(1)).Select(s => s.Id).ToList();
ItemSpplierIdCB.SelectedItem = null;
ItemSpplierIdCB.SelectedText = item.SupplierId.ToString();
}
}
}
