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,إضغط إضافة صنف"); } }