private void txtYear_Validating(object sender, CancelEventArgs e) { ReferencesValidation r = new ReferencesValidation(); if (r.yearValid(txtYear.Text) == false) { MessageBox.Show("Please enter is YYYY format."); txtYear.Focus(); } }
private void btnAdd_Click(object sender, EventArgs e) { Reference r = new Reference(); r.Title = txtTitle.Text; r.Authors_Fname = txtAuthors_Fname.Text; r.Authors_Lname = txtAuthors_Lname.Text; r.Document_type = txtDocumenttype.Text; r.Year = txtYear.Text; r.Publisher = txtPublisher.Text; r.City = txtCity.Text; r.Abstract = txtAbstract.Text; r.Name = txtName.Text; r.Issue = txtIssue.Text; r.Volume = txtVolume.Text; r.Pageno = txtPageno.Text; r.Notes = txtNotes.Text; r.Userid = userid; ReferencesValidation rv = new ReferencesValidation(); string[] parameters = new string[] { txtTitle.Text, txtAuthors_Fname.Text, txtAuthors_Lname.Text, txtDocumenttype.Text, txtYear.Text, txtPublisher.Text, txtAbstract.Text, txtName.Text, txtIssue.Text, txtVolume.Text, txtPageno.Text }; if (rv.checkEmpty(parameters) == true) { if (rv.numberValid(txtVolume.Text) == true) { if (rv.numberValid(txtPageno.Text) == true) { r.insert(); MessageBox.Show("Reference added sucessfully."); formclear(); } else { MessageBox.Show("Please enter numberic value for Page number."); txtPageno.Focus(); } } else { MessageBox.Show("Please enter numberic value for Page number."); txtVolume.Focus(); } } else { MessageBox.Show("Don't leave any field with * empty."); } }
private void btnSave_Click(object sender, EventArgs e) { ReferencesValidation rv = new ReferencesValidation(); string[] parameters = new string[] { txtTitle.Text, txtAuthors_Fname.Text, txtAuthors_Fname.Text, txtDocumenttype.Text, txtYear.Text, txtPublisher.Text, txtAbstract.Text, txtName.Text, txtIssue.Text, txtVolume.Text, txtPageno.Text }; if (rv.checkEmpty(parameters) == true) { if (rv.numberValid(txtPageno.Text) == true) { try { string qry = "update tbl_References set Title ='" + txtTitle.Text + "', Authors_Fname ='" + txtAuthors_Fname.Text + "', Authors_Lname ='" + txtAuthors_Lname.Text + "', Document_type ='" + txtDocumenttype.Text + "', Year ='" + txtYear.Text + "', Publisher ='" + txtPublisher.Text + "', City ='" + txtCity.Text + "', Abstract ='" + txtAbstract.Text + "', Name ='" + txtName.Text + "', Issue ='" + txtIssue.Text + "', Volume ='" + txtVolume.Text + "', Page_no =" + int.Parse(txtPageno.Text) + ", Notes ='" + txtNotes.Text + "' where Ref_Id =" + referenceId; DatabaseCon dbcon = new DatabaseCon(); dbcon.Query = qry; dbcon.ExecuteQuery(); MessageBox.Show("Done."); this.Close(); } catch (Exception ex) { throw ex; } } else { MessageBox.Show("Please enter numberic value for Page number."); txtPageno.Focus(); } } else { MessageBox.Show("Don't leave any field with * empty."); } }