private void Savebutton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(AttntextBox.Text)) { MessageBox.Show(@"Please Enter Attention", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); AttntextBox.Focus(); } else if (string.IsNullOrWhiteSpace(EmailtextBox.Text)) { MessageBox.Show(@"Please Enter Email", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); EmailtextBox.Focus(); } else if (string.IsNullOrWhiteSpace(SupliercomboBox.Text)) { MessageBox.Show(@"Please Select Supplier", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupliercomboBox.Focus(); } else { try { _con = new SqlConnection(_cs.DBConn); _con.Open(); string query1 = "insert into AttentionDetails(Attention,Email,SupplierId,UserId,CreationDate) values (@d1,@d2,@d3,@d4,@d5)" + "SELECT CONVERT(int, SCOPE_IDENTITY())"; _cmd = new SqlCommand(query1, _con); _cmd.Parameters.AddWithValue("@d1", AttntextBox.Text); _cmd.Parameters.AddWithValue("@d2", EmailtextBox.Text); _cmd.Parameters.AddWithValue("@d3", SupplierId); _cmd.Parameters.AddWithValue("@d4", nUserId); _cmd.Parameters.AddWithValue("@d5", DateTime.UtcNow.ToLocalTime()); _cmd.ExecuteNonQuery(); attnid = (int)_cmd.ExecuteScalar(); _con.Close(); MessageBox.Show("Saved successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); //Clear(); this.ReturnValue1 = AttntextBox.Text; this.ReturnValue2 = attnid.ToString(); this.DialogResult = DialogResult.OK; this.Close(); //this.ReturnValue1 = AttntextBox.Text; } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void Clear() { AttntextBox.Clear(); EmailtextBox.Clear(); SupliercomboBox.SelectedIndex = -1; }