Beispiel #1
0
        private void btnSaveContainer_Click(object sender, EventArgs e)
        {
            if (!IsAllRequiredTextFilled() || (cmbCtr3.Text.Trim() == string.Empty))
            {
                MessageBox.Show("لطفا همه فیلدها را پر کنید");
                ActiveControl = cmbBlNo;
                return;
            }

            try
            {
                //Save or Edit Ctr
                CTRViewModel ctr = new CTRViewModel
                {
                    txt1   = "CTR",
                    BolRef = int.Parse(cmbBlNo.SelectedValue.ToString()),
                    BolNo  = cmbBlNo.Text,
                    txt2   = txtCtr1.Text,
                    txt3   = txtCtr2.Text,
                    txt4   = lblCtr3.Text,
                    txt5   = txtCtr4.Text
                };
                if (ContainerEditID == 0)
                {
                    CTR.Insert(ctr);
                }
                else  //Update
                {
                    ctr.ID = int.Parse(dgvContainer.CurrentRow.Cells["ID"].Value.ToString());
                    CTR.Update(ctr);

                    cmbBlNo.Enabled = true;
                }

                //Empty All Textboxes
                foreach (Control c in gbContainer.Controls)
                {
                    if (c is TextBox)
                    {
                        c.Text = string.Empty;
                    }
                }
                cmbCtr3.Text = "";
                txtCtr4.Text = "0";

                progressBar3.Value = 50;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                dgvContainer.DataSource = CTR.GetAllData();

                RefreshCTR_cmb();
                btnSaveContainer.Text = "ذخیره کانتینر";
                ContainerEditID       = 0; gbKalaStatus();
            }
        }
        public static string[] WriteCtr(CTRViewModel _ct)
        {
            string[] _c = new string[5];
            _c[0] = _ct.txt1;
            _c[1] = _ct.txt2;
            _c[2] = _ct.txt3;
            _c[3] = _ct.txt4;
            _c[4] = _ct.txt5;

            return(_c.AddQutation());
        }
Beispiel #3
0
 public static bool Update(CTRViewModel _ctr)
 {
     try
     {
         using (IDbConnection db = new SQLiteConnection(DataAccess.GetConnectionString()))
         {
             string query = "UPDATE CTR SET BolRef =@BolRef, BolNo =@BolNo, txt1 =@txt1, txt2 =@txt2, txt3 =@txt3, txt4 =@txt4, txt5 =@txt5 where ID=@ID";
             db.Execute(query, _ctr);
         }
         return(true);
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
         return(false);
     }
 }
Beispiel #4
0
 public static bool Insert(CTRViewModel _ctr)
 {
     try
     {
         using (IDbConnection db = new SQLiteConnection(DataAccess.GetConnectionString()))
         {
             string query = "INSERT INTO CTR (BOLRef, BolNo, txt1, txt2, txt3, txt4, txt5) VALUES(@BOLRef, @BolNo, @txt1, @txt2, @txt3, @txt4, @txt5)";
             db.Execute(query, _ctr);
         }
         return(true);
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
         return(false);
     }
 }
Beispiel #5
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);
            }
        }