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; }