private void Btn_Add_Item_Click(object sender, EventArgs e)
{
dt.Clear();
Tbl_Daily_operation Daily_op = new Tbl_Daily_operation();
if (txt_Import_date.Text == "" || txt_receipt_num.Text == "")
{
txt_Import_date.Text = Convert.ToString(DateTime.Now);
var maxid = brada.Tbl_Daily_operations.Max(s => s.receipt_Code);
txt_receipt_num.Text = (maxid + 1).ToString();
}
groupBox4.Visible = false;
groupBox3.Visible = false;
txt_Packu_Cost.Clear();
txt_Item_Name.Clear();
txt_Quantity_Number.Clear();
Lbl_TotalCost.Text = "";
Btn_Impleme_Update.Visible = false;
Btn_Delete_Confirm.Visible = false;
Btn_Add_Item_Confirm.Visible = true;
Btn_Add_Item_Confirm.Text = "تأكيد الإضافة";
groupBox6.Visible = true;
label13.Text = "";
}
private void Btn_Add_Item_Confirm_Click(object sender, EventArgs e)
{
Tbl_Item Item = new Tbl_Item();
Tbl_Daily_operation DailyOperat = new Tbl_Daily_operation();
Tbl_Import Import = new Tbl_Import();
if (txt_Import_date.Text != "" && txt_receipt_num.Text != "")
{
if (search_ITems(txt_Item_Name.Text))
{
if (search_daily(txt_Item_Name.Text))//Update
{
MessageBox.Show("Refused");
txt_Item_Name.Text = txt_Quantity_Number.Text = Lbl_TotalCost.Text = txt_Packu_Cost.Text = "";
}
else//Insert
{
if (txt_Item_Name.Text != "" && txt_Quantity_Number.Text != "" && txt_Packu_Cost.Text != "" && Lbl_TotalCost.Text != "")
{
var date = Convert.ToDateTime(txt_Import_date.Text);
var receipt_num = Convert.ToInt32(txt_receipt_num.Text);
//--------------- Replace Subtracted values from Tbl_ITem Table---
var details = brada.Tbl_Items.Where(s => s.Item_Name == txt_Item_Name.Text).Select(s => new { ID = s.ID, Quantity__Item_Num = s.Quantity_Num }).SingleOrDefault();
int item_Code = details.ID;
int Quantity_tbl_Item_Num = details.Quantity__Item_Num;
int Quantity_Subtracted_DailyOPeration = Convert.ToInt32(txt_Quantity_Number.Text);
int Tbl_Item_Result_after_Subtract = Quantity_tbl_Item_Num - Quantity_Subtracted_DailyOPeration;
var ID = details.ID;
brada.Subtract_Update_Tbl_Item_Daily(ID, Tbl_Item_Result_after_Subtract);
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
DataGridViewRow row = dataGridView1.Rows[i];
var cel0 = row.Cells[0].Value.ToString();
var cel1 = row.Cells[1].Value.ToString();
var cel2 = row.Cells[2].Value.ToString();
var cel3 = row.Cells[3].Value.ToString();
//Insert values Directly from Gridview
//i=====>max+1 hالمفروض
brada.insert_Daily_Operation(i, item_Code, cel0, int.Parse(cel1), float.Parse(cel2), float.Parse(cel3), date, receipt_num);
brada.SubmitChanges();
}
label13.Text = "";
Btn_Add_Item_Confirm.Text = "تم الإضافة";
txt_receipt_num.Clear();
}
else
{
MessageBox.Show("برجاء املأ الخانات");
}
brada.SubmitChanges();
txt_Item_Name.Text = txt_Quantity_Number.Text = Lbl_TotalCost.Text = txt_Packu_Cost.Text = "";
}
}
else
{
MessageBox.Show(" إلغى هذا ! سيؤدى ذلك لخراب السيستم على إيدك يا مفترى ");
}
}
else
{
MessageBox.Show("Press Add Item,إضغط إضافة صنف");
}
}
