private void btnDelete_Click(object sender, EventArgs e)
{
string name = this.listBox1.SelectedItem.ToString();
try
{
this.btnDelete.Enabled = false;
using (WareHouseEntities en = new WareHouseEntities())
{
Material m = en.Materials.First(x => x.Name == name);
int id = m.ID;
foreach (InOut io in en.InOuts
.Where(x => x.MID == id))
{
en.InOuts.Remove(io);
}
en.SaveChanges();
en.Materials.Remove(m);
en.SaveChanges();
}
this.DisplayAllMaterials();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool AddInOut(InOut inOut)
{
try
{
using (WareHouseEntities en = new WareHouseEntities())
{
en.InOuts.Add(inOut);
en.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public static bool DeleteInOut(InOut InOut)
{
try
{
using (WareHouseEntities en = new WareHouseEntities())
{
InOut inOut = en.InOuts.First(x => x.ID == InOut.ID);
en.InOuts.Remove(inOut);
en.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
this.btnAdd.Enabled = false;
using (WareHouseEntities en = new WareHouseEntities())
{
Material m = new Material();
m.Name = this.txtName.Text.Trim();
m.Price = this.numPrice.Value;
en.Materials.Add(m);
en.SaveChanges();
}
this.DisplayAllMaterials();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool EditInOut(int oldInOutID, InOut newInOut)
{
try
{
using (WareHouseEntities en = new WareHouseEntities())
{
InOut inOut = en.InOuts.First(x => x.ID == oldInOutID);
inOut.MID = newInOut.MID;
inOut.Quantity = newInOut.Quantity;
inOut.Date = newInOut.Date;
en.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}