private void dgvMvtHeader_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int id = 0;
if (dgvMvtHeader.CurrentRow.Cells[0].Value != null)
{
id = Convert.ToInt32(dgvMvtHeader.CurrentRow.Cells[0].Value.ToString());
movement_header = db.movements_headers.Where(r => r.id == id).FirstOrDefault();
if (movement_header.approved == 0)
{
btnAccept.Enabled = true;
}
else
{
btnAccept.Enabled = false;
}
}
var m = (from a in db.movements.Where(x => x.mvt_id == id)
join b in db.unites on a.unit_id equals b.id
join c in db.items on a.item_id equals c.id
select new
{
الصنف = c.name,
الكمية = a.qty,
الوحدة = b.name
}
);
dgvMovements.DataSource = m;
btnPrint.Enabled = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
void save()
{
if (Cmb_stores.SelectedValue == null)
{
MessageBox.Show("الرجاء اختيار مخزن");
return;
}
var db = new DAL.dbDataContext();
if (movement_header.id == 0)
{
movement_header = new DAL.movements_header();
db.movements_headers.InsertOnSubmit(movement_header);
SetData();
db.SubmitChanges();
}
foreach (DataGridViewRow row in dgvItems.Rows)
{
movement = new DAL.movement();
movement.movements_header = movement_header;
movement.item_id = Convert.ToInt32(row.Cells["item_id"].Value);
movement.unit_id = Convert.ToInt32(row.Cells["unit_id"].Value);
movement.qty = Convert.ToDecimal(row.Cells["qty"].Value);
//movement.qty_unit = Convert.ToDecimal(row.Cells["unit_qty"].Value);
db.movements.InsertOnSubmit(movement);
db.SubmitChanges();
}
MessageBox.Show("تم الحفظ بنجاح");
New();
}
void New()
{
movement = new DAL.movement();
movement_header = new DAL.movements_header();
GetData();
DataTable d = new DataTable();
dgvItems.DataSource = d;
dgvItems.DataSource = null;
Cmb_type.SelectedIndex = 0;
}
