Exemplo n.º 1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                statuscatalogue   sc   = new statuscatalogue();
                StatusCatalogueDB SCDB = new StatusCatalogueDB();

                if (txtID.Text.Trim().Length == 0)
                {
                    MessageBox.Show("Fill Status ID.");
                }
                try
                {
                    string[] docmts = txtDocument.Text.Split('-');
                    sc.Rowid       = rowid;
                    sc.DocumentID  = docmts[1].Trim();
                    sc.ID          = Convert.ToInt32(txtID.Text.Trim());
                    sc.Description = txtDescription.Text.Trim().Replace("'", "''");
                }
                catch (Exception)
                {
                    sc.DocumentID  = "";
                    sc.ID          = 0;
                    sc.Description = "";
                    sc.Rowid       = 0;
                }

                sc.Status = getstatus(cmbStatus.SelectedItem.ToString());
                System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
                string btnText = btn.Text;
                if (btnText.Equals("Update"))
                {
                    if (SCDB.updateStatusCatalogue(sc))
                    {
                        MessageBox.Show("Status Catalogue Status updated");
                        closeAllPanels();
                        ListStatCatalogues();
                    }
                    else
                    {
                        MessageBox.Show("Failed to update Status Catalogue");
                    }
                }
                else if (btnText.Equals("Save"))
                {
                    if (SCDB.validateDocument(sc))
                    {
                        if (SCDB.insertStatusCatalogue(sc))
                        {
                            MessageBox.Show("Status Catalogue data Added");
                            closeAllPanels();
                            ListStatCatalogues();
                        }
                        else
                        {
                            MessageBox.Show("Failed to Insert Status Catalogue");
                        }
                    }
                    else
                    {
                        MessageBox.Show("Data Validation failed");
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Failed Adding / Editing User Data");
            }
        }