private void btnCancel_Click(object sender, EventArgs e)
{
Material_Releasing_Inquiry main = new Material_Releasing_Inquiry();
this.Hide();
main.Show();
}
private void TranSaveHeader(string Action)
{
string StringReturn = "";
string status = "";
if (Action == "SAVE" || Action == "ADDNEW")
{
status = "Saved";
}
if (Action == "SUBMIT")
{
status = "Submitted";
}
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TRAN_SAVE_MRI_HEADER";
cmd.Parameters.Add("@MRIID", SqlDbType.VarChar, 50).Value = txtMRIID.Text;
cmd.Parameters.Add("@MRINO", SqlDbType.VarChar, 50).Value = txtMRINo.Text;
cmd.Parameters.Add("@Status", SqlDbType.VarChar, 50).Value = status;
cmd.Parameters.Add("@DateOfRelease", SqlDbType.DateTime).Value = txtDateReleased.Text;
cmd.Parameters.Add("@IssuedFrom", SqlDbType.Int).Value = Convert.ToInt32(cmbIssueFrom.SelectedValue);
cmd.Parameters.Add("@IssuedTo", SqlDbType.Int).Value = Convert.ToInt32(cmbIssueTo.SelectedValue);
cmd.Parameters.Add("@RequestedBy", SqlDbType.Int).Value = Convert.ToInt32(cmbRequestedBy.SelectedValue);
cmd.Parameters.Add("@IssuedBy", SqlDbType.Int).Value = Convert.ToInt32(cmbIssuedBy.SelectedValue);
cmd.Parameters.Add("@VerifiedBy", SqlDbType.Int).Value = Convert.ToInt32(cmbVerifiedBy.SelectedValue);
cmd.Parameters.Add("@UserCreated", SqlDbType.Int).Value = Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@WithIssue", SqlDbType.Bit).Value = Convert.ToBoolean(chkIssues.Checked); //Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 50).Value = rtxtRemarks.Text; //Convert.ToBoolean(chkIssues.Checked); //Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@ReferenceNo", SqlDbType.VarChar, 10).Value = txtReferenceNo.Text; //rtxtRemarks.Text; //Convert.ToBoolean(chkIssues.Checked); //Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@CurrencyCode", SqlDbType.VarChar, 10).Value = cmbCurrencyCode.SelectedValue.ToString(); //rtxtRemarks.Text; //Convert.ToBoolean(chkIssues.Checked); //Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@TranType", SqlDbType.VarChar, 10).Value = txttrantype.Text;
cmd.Connection = con;
try
{
con.Open();
StringReturn = cmd.ExecuteScalar().ToString();
ItemMasterLookUp formTask = new ItemMasterLookUp();
if (Action == "SAVE" || Action == "SUBMIT")
{
if (Action == "SAVE")
{
MessageBox.Show("Record Saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
if (Action == "SUBMIT")
{
MessageBox.Show("Record Submitted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
Material_Releasing_Inquiry formTask2 = new Material_Releasing_Inquiry();
formTask2.GetUserID(TxtUserID.Text);
formTask2.GetTranType(txttrantype.Text);
this.Dispose();
formTask2.Show();
}
if (Action == "ADDNEW")
{
formTask.Test(StringReturn, txttrantype.Text.ToString());
formTask.GetUserID(TxtUserID.Text);
formTask.GetTranType(txttrantype.Text, cmbIssueFrom.SelectedValue.ToString());
this.Dispose();
formTask.Show();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}