private void Form6_Load(object sender, EventArgs e) { System.Globalization.CultureInfo language = new System.Globalization.CultureInfo("en-us"); InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(language); dgvContainer.AutoGenerateColumns = false; dgvKala.AutoGenerateColumns = false; if (CTR.GetAllData().Count > 0) { dgvContainer.DataSource = CTR.GetAllData(); } gbKalaStatus(); if (dgvKala.Enabled) { dgvKala.DataSource = CONN.GetAllData(); } cmbBlNo.DataSource = BOL.GetAllData(); cmbBlNo.DisplayMember = "txt2"; cmbBlNo.ValueMember = "ID"; cmb07.DataSource = PackageCodes.GetAllData(); cmb07.DisplayMember = "Full"; cmb07.ValueMember = "Code"; cmb07.Text = ""; loadTooltips(); }
private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == EditCol.Index) //Edit { EditID = int.Parse(dgv.CurrentRow.Cells["ID"].Value.ToString()); var con = CONN.GetById(EditID); txt01.Text = con.txt2; txt02.Text = con.txt3; txt03.Text = con.txt4; txt05.Text = con.txt6; txt06.Text = con.txt7; cmb08.Text = con.txt8; cmb07.Text = con.txt9; txt09.Text = con.txt10; txt10.Text = con.txt11; cmb12.Text = con.txt13; cmb18.Text = con.txt19; btnSave.Text = "ذخیره تغییرات"; } if (e.ColumnIndex == DelCol.Index) //Del { if (MessageBox.Show("آیا مایلید کالای مورد نظر حذف شود؟" , "Delete" , MessageBoxButtons.YesNo , MessageBoxIcon.Question , MessageBoxDefaultButton.Button2 ) == DialogResult.Yes) { try { CONN.Delete(int.Parse(dgv.CurrentRow.Cells["ID"].Value.ToString())); dgv.DataSource = CONN.GetAllData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void btnRefreshKala_Click(object sender, EventArgs e) => dgvKala.DataSource = CONN.GetAllData();
private void dgvKala_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == KalaEditCol.Index) //Edit { try { cmbContainerNumber.Enabled = false; KalaEditID = int.Parse(dgvKala.CurrentRow.Cells["KALA_ID"].Value.ToString()); var conn = CONN.GetById(KalaEditID); cmbContainerNumber.Text = conn.CTRNo; txt01.Text = conn.txt2; txt02.Text = conn.txt3; txt03.Text = conn.txt4; txt05.Text = conn.txt6; txt06.Text = conn.txt7; cmb08.Text = conn.txt8; cmb07.Text = conn.txt9; txt09.Text = conn.txt10; txt10.Text = conn.txt11; txt11.Text = conn.txt12; cmb12.Text = conn.txt13; cmb18.Text = conn.txt19; btnSaveKala.Text = "ذخیره تغییرات"; } catch (Exception ex) { MessageBox.Show("خطا در خواندن اطلاعات\nError: " + ex.Message); } } if (e.ColumnIndex == KalaDelCol.Index) //Del { if (MessageBox.Show("آیا مایلید کالای مورد نظر حذف شود؟" , "Delete" , MessageBoxButtons.YesNo , MessageBoxIcon.Question , MessageBoxDefaultButton.Button2 ) == DialogResult.Yes) { try { CONN.Delete(int.Parse(dgvKala.CurrentRow.Cells["KALA_ID"].Value.ToString())); if (dgvKala.Rows.Count == 0) { progressBar3.Value = 50; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { dgvKala.DataSource = null; dgvKala.DataSource = CONN.GetAllData(); } } } }
private void btnSaveKala_Click(object sender, EventArgs e) { try { CONNViewModel cons = new CONNViewModel { CTRRef = int.Parse(cmbContainerNumber.SelectedValue.ToString()), CTRNo = cmbContainerNumber.Text, //BolRef = int.Parse(cmbBlNo.SelectedValue.ToString()), //BolNo = cmbBlNo.Text, txt1 = "CON", txt2 = txt01.Text, txt3 = txt02.Text, txt4 = txt03.Text, txt6 = txt05.Text, txt7 = txt06.Text, txt8 = cmb08.Text, txt9 = cmb07.Text, txt10 = txt09.Text, txt11 = txt10.Text, txt12 = txt11.Text, txt13 = cmb12.Text, txt19 = cmb18.Text, }; if (KalaEditID == 0)//Save { CONN.Insert(cons); } else //Edit { cons.ID = int.Parse(dgvKala.CurrentRow.Cells["KALA_ID"].Value.ToString()); CONN.Update(cons); cmbContainerNumber.Enabled = true; btnSaveKala.Text = "ذخیره کالا"; } //Empty All Textboxes foreach (Control c1 in tabRequired.Controls) { if (c1 is TextBox) { c1.Text = string.Empty; } } SetTabPage2Defaults(); progressBar3.Value = 75; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { //Refresh dgv dgvKala.DataSource = null; dgvKala.DataSource = CONN.GetAllData(); KalaEditID = 0; btnSaveKala.Text = "دخیره کالا"; } }
private void dgvContainer_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == EditCol.Index) //Edit { try { cmbBlNo.Enabled = false; gbKala.Enabled = false; ContainerEditID = int.Parse(dgvContainer.CurrentRow.Cells["ID"].Value.ToString()); var ctr = CTR.GetById(ContainerEditID); cmbBlNo.Text = ctr.BolNo; txtCtr1.Text = ctr.txt2; txtCtr2.Text = ctr.txt3; cmbCtr3.Text = ctr.txt4; lblCtr3.Text = ctr.txt4; txtCtr4.Text = ctr.txt5; btnSaveContainer.Text = "ذخیره تغییرات"; } catch (Exception ex) { MessageBox.Show("خطا در خواندن اطلاعات\nError:" + ex.Message); } } if (e.ColumnIndex == DelCol.Index) //Del { if (MessageBox.Show("آیا مایلید کانتینر مورد نظر با کالاهای آن حذف شود؟" , "Delete" , MessageBoxButtons.YesNo , MessageBoxIcon.Question , MessageBoxDefaultButton.Button2 ) == DialogResult.Yes) { try { int _id = int.Parse(dgvContainer.CurrentRow.Cells["ID"].Value.ToString()); CONN.DeleteByCTRID(_id); CTR.Delete(_id); if (dgvContainer.Rows.Count == 0) { progressBar3.Value = 25; } } catch (Exception ex) { MessageBox.Show("خطا در خواندن اطلاعات\nError:" + ex.Message); } finally { dgvContainer.DataSource = null; dgvContainer.DataSource = CTR.GetAllData(); RefreshCTR_cmb(); dgvKala.DataSource = null; if (dgvKala.Enabled) { dgvKala.DataSource = CONN.GetAllData(); } } } } }