Exemple #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                documentnumber   dn     = new documentnumber();
                DocumentNumberDB DnDB   = new DocumentNumberDB();
                string[]         docmts = txtDocument.Text.Split('-');
                dn.rowid        = DRowID;
                dn.fyID         = cmbFY.SelectedItem.ToString().Trim().Substring(0, cmbFY.SelectedItem.ToString().Trim().IndexOf(':')).Trim();
                dn.DocumentID   = docmts[1];
                dn.DocumentName = docmts[0];
                dn.TemporaryNo  = Convert.ToInt32(txtTempno.Text);
                dn.DocumentNo   = Convert.ToInt32(txtDocumentNo.Text);

                System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
                string btnText = btn.Text;
                if (DnDB.validateDocumentNo(dn))
                {
                    if (btnText.Equals("Update"))
                    {
                        if (DnDB.updateDocumentnumber(dn))
                        {
                            MessageBox.Show("Document Number updated");
                            closeAllPanels();
                            ListOffice();
                        }
                        else
                        {
                            MessageBox.Show("Failed to update Document Number");
                        }
                    }
                    else if (btnText.Equals("Save"))
                    {
                        if (DnDB.insertDocument(dn))
                        {
                            MessageBox.Show("Document Number Added");
                            closeAllPanels();
                            ListOffice();
                        }
                        else
                        {
                            MessageBox.Show("Failed to Insert Document Number");
                        }
                    }
                }
                else
                {
                    MessageBox.Show("Document Number Data Validation failed");
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Failed Adding / Editing Document Number");
            }
        }
Exemple #2
0
 private void ListOffice()
 {
     try
     {
         grdList.Rows.Clear();
         DocumentNumberDB      dbrecord = new DocumentNumberDB();
         List <documentnumber> docnum   = dbrecord.getDocumentNo();
         foreach (documentnumber doc in docnum)
         {
             grdList.Rows.Add(doc.rowid, doc.fyID, doc.DocumentID,
                              doc.DocumentName, doc.TemporaryNo, doc.DocumentNo);
         }
     }
     catch (Exception)
     {
         MessageBox.Show("Error in Document Number listing");
     }
     enableBottomButtons();
     pnlOfficeList.Visible = true;
 }
Exemple #3
0
        private void btnSave_Click_1(object sender, EventArgs e)
        {
            Boolean status = true;

            try
            {
                SMRNDB smrnhDB = new SMRNDB();
                smrn   smrnh   = new smrn();
                try
                {
                    ////////smrnh.CourierID = cmbCourierID.SelectedItem.ToString().Trim().Substring(0,cmbCourierID.SelectedItem.ToString().Trim().IndexOf('-'));
                    smrnh.CourierID = ((Structures.ComboBoxItem)cmbCourierID.SelectedItem).HiddenValue;
                    //////////smrnh.CustomerID = cmbCustomer.SelectedItem.ToString().Trim().Substring(0, cmbCustomer.SelectedItem.ToString().Trim().IndexOf('-'));
                    smrnh.CustomerID = ((Structures.ComboBoxItem)cmbCustomer.SelectedItem).HiddenValue;
                }
                catch (Exception)
                {
                    smrnh.CustomerID   = "";
                    smrnh.CustomerName = "";
                }
                smrnh.DocumentID = docID;

                smrnh.SMRNDate             = dtSMRNDate.Value;
                smrnh.CustomerDocumentDate = dtCustomerDocDate.Value;
                smrnh.Remarks            = txtRemarks.Text;
                smrnh.NoOfPackets        = Convert.ToInt32(txtNoOfPacket.Text);
                smrnh.CustomerDocumentNo = txtCuxtomerDocNo.Text;

                string btnText = btnSave.Text;
                if (btnText.Equals("Update"))
                {
                    smrnh.ForwarderList = prevsh.ForwarderList;
                    smrnh.SMRNNo        = Convert.ToInt32(txtSMRNNo.Text);
                    if (smrnhDB.validateSMRN(smrnh))
                    {
                        if (smrnhDB.updateSMRN(smrnh, prevsh))
                        {
                            MessageBox.Show("SMRN updated");
                            closeAllPanels();
                            listOption = 1;
                            ListFilteredSMRN(listOption);
                        }
                        else
                        {
                            status = false;
                            MessageBox.Show("Failed to update SMRN");
                        }
                    }
                    else
                    {
                        status = false;
                        MessageBox.Show("Smrn DEtail Entered Wrong");
                    }
                }
                else if (btnText.Equals("Save"))
                {
                    smrnh.DocumentStatus = 1;//created
                    smrnh.SMRNDate       = UpdateTable.getSQLDateTime();
                    smrnh.SMRNNo         = DocumentNumberDB.getNewNumber(docID, 1);
                    if (smrnhDB.validateSMRN(smrnh))
                    {
                        if (smrnhDB.insertSMRN(smrnh))
                        {
                            MessageBox.Show("SMRN Added");
                            closeAllPanels();
                            listOption = 1;
                            ListFilteredSMRN(listOption);
                        }
                        else
                        {
                            MessageBox.Show("Failed to Insert SMRN");
                            status = false;
                        }
                    }
                    else
                    {
                        status = false;
                        MessageBox.Show("Smrn DEtail Entered Wrong");
                    }
                }
                else
                {
                    status = false;
                    MessageBox.Show("SMRN Data Operation failed");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed Adding / Editing SMRN");
                status = false;
            }
            if (status)
            {
                setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save
            }
        }
Exemple #4
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            Boolean status = true;

            try
            {
                List <smrnservicedlist>     SMRNServList;
                SMRNServicedListDB          ServListDB = new SMRNServicedListDB();
                smrnservicedlist            ServList   = new smrnservicedlist();
                System.Windows.Forms.Button btn        = sender as System.Windows.Forms.Button;
                string btnText = btnSave.Text;
                try
                {
                    ServList.DocumentID = docID;
                    smrnservicedlist smrnserv;
                    SMRNServList = new List <smrnservicedlist>();
                    for (int i = 0; i < grdSMRNServList.Rows.Count; i++)
                    {
                        try
                        {
                            DataGridViewCheckBoxCell cell = grdSMRNServList.Rows[i].Cells["check"] as DataGridViewCheckBoxCell;
                            if (cell.Value != null)
                            {
                                if (Convert.ToBoolean(cell.Value) == true)
                                {
                                    smrnserv = new smrnservicedlist();
                                    smrnserv.SMRNHeaderNo   = Convert.ToInt32(grdSMRNServList.Rows[i].Cells["gSMRNHeaderNo"].Value.ToString().Trim());
                                    smrnserv.SMRNHeaderDate = Convert.ToDateTime(grdSMRNServList.Rows[i].Cells["gSMRNHeaderDate"].Value.ToString().Trim());
                                    smrnserv.JobIDNo        = Convert.ToInt32(grdSMRNServList.Rows[i].Cells["JobId"].Value.ToString().Trim());
                                    smrnserv.ListNo         = Convert.ToInt32(grdSMRNServList.Rows[i].Cells["gTemporaryNo"].Value.ToString().Trim());      /// For storing TemporaryNo of SMRNDetail
                                    smrnserv.ListDate       = Convert.ToDateTime(grdSMRNServList.Rows[i].Cells["gTemporaryDate"].Value.ToString().Trim()); ////for storing temporaryDate of SMRNdetail
                                    SMRNServList.Add(smrnserv);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show("createAndUpdateSMRNDetails() : Error creating SMRN Details");
                            status = false;
                            return;
                        }
                    }
                    ServList.Status = 1;
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Validation failed");
                    return;
                }
                if (btnText.Equals("Save"))
                {
                    ServList.ListNo         = DocumentNumberDB.getNewNumber(docID, 1);
                    ServList.DocumentStatus = 1;
                    ServList.ListDate       = UpdateTable.getSQLDateTime();
                }
                else
                {
                    ServList.ListNo         = Convert.ToInt32(txtListNo.Text);
                    ServList.DocumentStatus = prevservlist.DocumentStatus;
                    ServList.ListDate       = prevservlist.ListDate;
                }
                if (btnText.Equals("Save"))
                {
                    if (ServListDB.updateSMRNServicedList(ServList, SMRNServList, 1))
                    {
                        MessageBox.Show("SMRNService List Details Added");
                        closeAllPanels();
                        listOption = 1;
                        ListFilteredSMRNServiceList(listOption);
                    }
                    else
                    {
                        status = false;
                    }
                    if (!status)
                    {
                        MessageBox.Show("Failed to Insert SMRNServiceList");
                        status = false;
                    }
                }
                else
                {
                    MessageBox.Show("SMRNServiceList Validation failed");
                    status = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("SMRNServiceList Validation failed");
                status = false;
            }
            if (status)
            {
                setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save
            }
        }