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;
}
