private void BtImpEditPro_Click(object sender, EventArgs e)
{
var IdBill = Convert.ToInt16(DgvImp.CurrentRow.Cells["ID"].Value.ToString());
List <DetailImport> List = new List <DetailImport>();
for (int i = 0; i < DgvImpPro.RowCount; i++)
{
DetailImport Pro = new DetailImport();
var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString();
Pro.IDProduct = Convert.ToInt16(str);
Pro.IDBill = IdBill;
var Quan = DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString();
Pro.Quantity = Convert.ToInt16(Quan);
//var Detail = db.DetailImports.Where(p => p.IDBill == IdBill && p.IDProduct == IDProduct).SingleOrDefault();
List.Add(Pro);
}
var IDPro = Convert.ToInt16(DgvImpPro.CurrentRow.Cells["ID"].Value.ToString());
var result = db.Products.Find(IDPro);
var ProImp = List.Where(p => p.IDBill == IdBill && p.IDProduct == IDPro).SingleOrDefault();
List.Remove(ProImp);
DetailImport ImpPro = new DetailImport();
ImpPro.IDBill = IdBill;
ImpPro.IDProduct = IDPro;
string quan = TxtImpProQuan.Text;
ImpPro.Quantity = Convert.ToInt16(quan);
List.Add(ImpPro);
LoadPro(List);
}
private void BtImpDeletePro_Click(object sender, EventArgs e)
{
List <DetailImport> List = new List <DetailImport>();
var IdBill = DgvImp.CurrentRow.Cells["ID"].Value.ToString();
int Bill = Convert.ToInt16(IdBill);
for (int i = 0; i < DgvImpPro.RowCount; i++)
{
DetailImport ImpPro = new DetailImport();
var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString();
ImpPro.IDProduct = Convert.ToInt16(str);
ImpPro.IDBill = Bill;
var quan = DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString();
ImpPro.Quantity = Convert.ToInt16(quan);
List.Add(ImpPro);
}
var IdPro = DgvImpPro.CurrentRow.Cells["ID"].Value.ToString();
int Pro = Convert.ToInt16(IdPro);
var ProImp = List.Where(p => p.IDProduct == Pro).SingleOrDefault();
List.Remove(ProImp);
LoadPro(List);
TxtImpProCode.Clear();
TxtImpProName.Clear();
TxtImpProUnit.Clear();
TxtImpProQuan.Clear();
}
private void BtImpAddPro_Click(object sender, EventArgs e)
{
List <DetailImport> ListPro = new List <DetailImport>();
DetailImport ProImp = new DetailImport();
var Id = Convert.ToInt32(DgvImp.CurrentRow.Cells["ID"].Value.ToString());
for (int i = 0; i < DgvImpPro.RowCount; i++)
{
var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString();
var IDProduct = Convert.ToInt16(str);
var Detail = db.DetailImports.Where(p => p.IDBill == Id && p.IDProduct == IDProduct).SingleOrDefault();
ListPro.Add(Detail);
}
var result = db.Products.Where(p => p.Code == TxtImpProCode.Text).SingleOrDefault();
if (result == null)
{
MessageBox.Show("There isn't this item in the storehouse, Click to add product");
return;
}
else
{
TxtImpProName.Text = result.Name;
TxtImpProUnit.Text = result.Unit;
CbImpProSup.SelectedValue = result.IdCom;
ProImp.IDBill = Id;
ProImp.IDProduct = result.ID;
ProImp.Quantity = Convert.ToInt16(TxtImpProQuan.Text);
ListPro.Add(ProImp);
LoadPro(ListPro);
}
}
private void BtImpEdit_Click(object sender, EventArgs e)
{
var IdBill = DgvImp.CurrentRow.Cells["ID"].Value.ToString();
int ID = Convert.ToInt16(IdBill);
var Bill = db.BillImports.Find(ID);
Bill.IDCompany = Convert.ToInt16(CbImpSupplier.SelectedValue.ToString());
Bill.NameCustom = TxtImpDeliver.Text;
var IDsto = Convert.ToInt16(TxtImpStoID.Text);
Bill.IDStoreKeeper = IDsto;
Bill.DateImport = DateImp.Value;
if (MessageBox.Show("Do you want to save changes?", "", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
var result = db.DetailImports.Where(p => p.IDBill == ID).ToList();
for (int i = 0; i < result.Count; i++)
{
db.DetailImports.Remove(result[i]);
db.SaveChanges();
}
for (int i = 0; i < DgvImpPro.RowCount; i++)
{
DetailImport Detail = new DetailImport();
Detail.IDBill = Bill.ID;
Detail.IDProduct = Convert.ToInt16(DgvImpPro.Rows[i].Cells["ID"].Value.ToString());
var res = db.DetailImports.Where(p => p.IDBill == Detail.IDBill && p.IDProduct == Detail.IDProduct).SingleOrDefault();
if (res != null)
{
res.Quantity = res.Quantity + Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString());
db.SaveChanges();
}
else
{
Detail.Quantity = Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString());
db.DetailImports.Add(Detail);
db.SaveChanges();
}
}
db.SaveChanges();
LoadDgv();
LoadDetail();
LoadDgvPro();
LoadDetailPro();
}
else
{
return;
}
}
private void BtImpCreate_Click(object sender, EventArgs e)
{
if (TxtImpStorekeeper.Text == "" || TxtImpDeliver.Text == "")
{
MessageBox.Show("Fill in all information");
return;
}
BillImport Bill = new BillImport();
Bill.IDCompany = Convert.ToInt16(CbImpSupplier.SelectedValue.ToString());
Bill.IDStoreKeeper = Medium.IdSto;
Bill.NameCustom = TxtImpDeliver.Text;
Bill.DateImport = DateImp.Value;
db.BillImports.Add(Bill);
db.SaveChanges();
for (int i = 0; i < DgvImpPro.RowCount; i++)
{
DetailImport Detail = new DetailImport();
Detail.IDBill = Bill.ID;
Detail.IDProduct = Convert.ToInt16(DgvImpPro.Rows[i].Cells["ID"].Value.ToString());
var res = db.DetailImports.Where(p => p.IDBill == Detail.IDBill && p.IDProduct == Detail.IDProduct).SingleOrDefault();
if (res != null)
{
res.Quantity = res.Quantity + Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString());
db.SaveChanges();
}
else
{
Detail.Quantity = Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString());
db.DetailImports.Add(Detail);
db.SaveChanges();
}
}
MessageBox.Show("Add Item successfully");
LoadDgv();
LoadDetail();
LoadDgvPro();
LoadDetailPro();
}
