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