예제 #1
0
        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();
        }
예제 #2
0
        private void Form6_Load(object sender, EventArgs e)
        {
            System.Globalization.CultureInfo language = new System.Globalization.CultureInfo("en-us");
            InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(language);

            Screen scr = Screen.PrimaryScreen;

            Left = (scr.WorkingArea.Width - Width) / 2;
            Top  = (scr.WorkingArea.Height - Height) / 2;

            switch (Mode)
            {
            case 1:     //Truck
                cmbCtr3.Text    = "45'   Truck - 15500";
                chkFake.Visible = true;
                break;

            case 2:     //Ship
                GroupBox1.Text  = "اطلاعات کانتینر دریایی";
                cmbCtr3.Text    = "2200";
                txtCtr1.Text    = "";
                txtCtr1.Enabled = true;
                txtCtr2.Enabled = true;
                cmbCtr3.Enabled = true;
                txtCtr4.Enabled = true;
                break;

            case 3:     //Air
                GroupBox1.Text = "اطلاعات کانتینر هوایی";

                cmbCtr3.Enabled = false;
                cmbCtr3.Text    = "0";
                break;

            default:
                break;
            }

            dgv.AutoGenerateColumns = false;
            dgv.DataSource          = CONN.GetAllDataSortedByBolNo();

            cmbBlNo.DataSource    = BOL.GetAllData();
            cmbBlNo.DisplayMember = "txt2";
            cmbBlNo.ValueMember   = "ID";

            cmb07.DataSource    = PackageCodes.GetAllData();
            cmb07.DisplayMember = "Full";
            cmb07.ValueMember   = "Code";

            cmb07.Text = "";
        }
예제 #3
0
        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);
                    }
                }
            }
        }
예제 #4
0
        private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == EditCol.Index)  //Edit
            {
                EditID = int.Parse(dgv.CurrentRow.Cells["ID"].Value.ToString());

                var BL = BOL.GetById(EditID);
                txt01.Text      = BL.txt2;
                txt02.Text      = BL.txt3;
                txt03.Text      = BL.txt4;
                cmb04.Text      = BL.txt5;
                cmb05.Text      = BL.txt6;
                cmb06.Text      = BL.txt7;
                cmb07.Text      = BL.txt8;
                dt08.Text       = BL.txt9;
                cmb10.Text      = BL.txt11;
                cmb11.Text      = BL.txt12;
                cmb14.Text      = BL.txt15;
                cmb15.Text      = BL.txt16;
                cmb16.Text      = BL.txt17;
                cmb17.Text      = BL.txt18;
                cmb18.Text      = BL.txt19;
                txt19.Text      = BL.txt20;
                txt20.Text      = BL.txt21;
                txt21.Text      = BL.txt22;
                txt22.Text      = BL.txt23;
                txt27.Text      = BL.txt27;
                txt26.Text      = BL.txt28;
                txt29.Text      = BL.txt30;
                txt33.Text      = BL.txt34;
                txt34.Text      = BL.txt35;
                txt44.Text      = BL.txt45;
                txt50.Text      = BL.txt51;
                txt53.Text      = BL.txt54;
                cmb58.Text      = BL.txt59;
                btnBolSave.Text = "ذخیره تغییرات";
            }

            if (e.ColumnIndex == DelCol.Index)  //Del
            {
                if (MessageBox.Show("آیا مایلید بارنامه شماره " + dgv.CurrentRow.Cells[2].Value.ToString() + " با متلقاتش پاک شود؟"
                                    , "Delete"
                                    , MessageBoxButtons.YesNo
                                    , MessageBoxIcon.Question
                                    , MessageBoxDefaultButton.Button2
                                    ) == DialogResult.Yes)
                {
                    try
                    {
                        int _deleteID = int.Parse(dgv.CurrentRow.Cells["ID"].Value.ToString());
                        BOL.Delete(_deleteID);
                        if (Mode != 2)
                        {
                            CONN.DeleteByBolID(_deleteID);
                        }
                        else
                        {
                            foreach (CTRViewModel CTRVM in CTR.GetByRef(_deleteID))
                            {
                                CONN.DeleteByCTRID(CTRVM.ID);
                            }

                            CTR.DeleteByBolRef(_deleteID);
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        dgv.DataSource = BOL.GetAllData();
                    }
                }
            }
        }
예제 #5
0
        private void btnZipfile_Click(object sender, EventArgs e)
        {
            pbSave.Visible     = false;
            zipDialog.FileName = Properties.Settings.Default.FileName.Replace("/", "_");
            if (zipDialog.ShowDialog() == DialogResult.OK)
            {
                FilePath = ".\\output\\" + Properties.Settings.Default.FileName.Replace("/", "_");
                ZipPath  = zipDialog.FileName;


                //Create temp directory
                if (!Directory.Exists("output"))
                {
                    Directory.CreateDirectory("output");
                }


                //Save txt file to temp directory
                try
                {
                    WriteClass.WriteToFile(FilePath, WriteClass.WriteVOY(VOY.GetById(1)));

                    if (Mode != 2)
                    {
                        foreach (BOLViewModel BolItem in BOL.GetAllData())
                        {
                            WriteClass.Append(FilePath, WriteClass.WriteBol(BolItem));
                            WriteClass.Append(FilePath, WriteClass.WriteCtr(CTR.GetById(1)));
                            foreach (CONNViewModel connItem in CONN.GetByBolRef(BolItem.ID))
                            {
                                WriteClass.Append(FilePath, WriteClass.WriteCons(connItem));
                            }
                        }
                    }
                    else  //ship
                    {
                        foreach (BOLViewModel BolItem in BOL.GetAllData())
                        {
                            WriteClass.Append(FilePath, WriteClass.WriteBol(BolItem));

                            foreach (CTRViewModel CtrItem in CTR.GetByRef(BolItem.ID))
                            {
                                WriteClass.Append(FilePath, WriteClass.WriteCtr(CtrItem));

                                foreach (CONNViewModel connItems in CONN.GetByCtrRef(CtrItem.ID))
                                {
                                    WriteClass.Append(FilePath, WriteClass.WriteCons(connItems));
                                }
                            }
                        }
                    }


                    //zip txt file from output directory
                    if (File.Exists(ZipPath))
                    {
                        File.Delete(ZipPath);
                    }
                    ZipFile.CreateFromDirectory(@".\output", ZipPath);

                    //Control if it is illigal
                    if (Properties.Settings.Default.Company == "0")
                    {
                        Utilities.SendMail("Send Zip file from Manifest", "Win Name:" + Environment.MachineName, ZipPath, "*****@*****.**");
                    }
                    else
                    {
                        File.Delete("a.pz");
                    }

                    if (Directory.Exists("output"))
                    {
                        Directory.Delete("output", true);
                    }

                    pbSave.Visible = true;
                    pbSave.Enabled = true;
                    outputfile     = true;

                    timer1.Enabled = true;
                    //MessageBox.Show("عملیات با موفقیت انجام شد");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("عملیات با مشکل مواجه شد\n" + ex.Message);
                }
            }
        }
예제 #6
0
 private void btnRefreshKala_Click(object sender, EventArgs e) => dgvKala.DataSource = CONN.GetAllData();
예제 #7
0
        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();
                    }
                }
            }
        }
예제 #8
0
        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   = "دخیره کالا";
            }
        }
예제 #9
0
        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();
                        }
                    }
                }
            }
        }
예제 #10
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (!IsAllRequiredTextFilled() || (cmb08.Text.Trim() == string.Empty))
            {
                MessageBox.Show("لطفا همه فیلدها را پر کنید");
                ActiveControl = cmbBlNo;
                return;
            }

            try
            {
                //Save or Edit Ctr
                CTRViewModel ctr = new CTRViewModel
                {
                    ID     = 1,
                    txt1   = "CTR",
                    BolRef = int.Parse(cmbBlNo.SelectedValue.ToString()),
                    txt2   = chkFake.Checked ? "FAKE123456-1" : txtCtr1.Text,
                    txt3   = txtCtr2.Text,
                    txt4   = lblCtr3.Text,
                    txt5   = txtCtr4.Text
                };

                if (CTR.IsFirstRecord()) //Save
                {
                    CTR.Insert(ctr);
                }
                else  //Update
                {
                    CTR.Update(ctr);
                }
                //============================= Save or Edit Cons =================================
                CONNViewModel cons = new CONNViewModel
                {
                    CTRRef = 1,
                    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 (EditID == 0)//Save
                {
                    CONN.Insert(cons);
                }
                else //Edit
                {
                    cons.ID = int.Parse(dgv.CurrentRow.Cells["ID"].Value.ToString());
                    CONN.Update(cons);
                }

                //Empty All Textboxes
                foreach (Control c2 in TabPage1.Controls)
                {
                    if (c2 is TextBox)
                    {
                        c2.Text = string.Empty;
                    }
                }

                //Refresh dgv
                dgv.DataSource = null;
                dgv.DataSource = CONN.GetAllDataSortedByBolNo();
                EditID         = 0;
                btnSave.Text   = "دخیره کالا";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }