public static Nullable <int> AddDisposalReason(DisposalReason aDisposalReason)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO DisposalReason (Name,Comment) VALUES (@Name,@Comment)", Helper.Instance.con);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = aDisposalReason.Disposal_Detailed_Name;
cmd.Parameters.Add("@Comment", SqlDbType.NVarChar).Value = aDisposalReason.Disposal_Detailed_Comment;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(1);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
MessageBox.Show("ERROR IN DisposalReason MGMT (AddDisposalReason FUNCTION) EX=" + ex.Message.ToString());
return(0);
}
}
else
{
return(null);
}
}
private void AddDisposalReasonBtn_Click(object sender, EventArgs e)
{
if (Validators.TxtBoxNotEmpty(NameTxtBox.Text))
{
if (Validators.TxtBoxNotEmpty(DescriptionTxtBox.Text))
{
DisposalReason aDisposalReason = new DisposalReason();
aDisposalReason.Disposal_Detailed_Name = NameTxtBox.Text;
aDisposalReason.Disposal_Detailed_Comment = DescriptionTxtBox.Text;
Nullable <int> IsAddDisposalReasonOK = DisposalReasonMgmt.AddDisposalReason(aDisposalReason);
if (IsAddDisposalReasonOK == 1)
{
MessageBox.Show(MsgTxt.DisposalReasonTxt + NameTxtBox.Text + "\n" + MsgTxt.AddedSuccessfully, MsgTxt.AddedSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DataBase Error: AddDisposalReasonBtn_Click] \n Exception: \n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
else
{
MessageBox.Show(MsgTxt.PleaseAddAllRequiredFields + "\n" + "1)" + MsgTxt.DescriptionTxt, MsgTxt.PleaseAddAllRequiredFields, MessageBoxButtons.OK, MessageBoxIcon.Warning);
DescriptionTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
DescriptionTxtBox.Focus();
NameTxtBox.BackColor = NameBGColor;
}
}
else
{
MessageBox.Show(MsgTxt.PleaseAddAllRequiredFields + "\n" + "1)" + MsgTxt.NameTxt + "\n 2)" + MsgTxt.DescriptionTxt, MsgTxt.PleaseAddAllRequiredFields, MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (!Validators.TxtBoxNotEmpty(DescriptionTxtBox.Text))
{
DescriptionTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
DescriptionTxtBox.Focus();
}
else
{
DescriptionTxtBox.BackColor = DescBGColor;
}
if (!Validators.TxtBoxNotEmpty(NameTxtBox.Text))
{
NameTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
NameTxtBox.Focus();
}
else
{
NameTxtBox.BackColor = NameBGColor;
}
}
}