private void linkLabel28_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
StallionSuppyChain.Purchase_Order.POInquiry PO = new StallionSuppyChain.Purchase_Order.POInquiry();
PO.GetUserID(TxtUserID.Text);
PO.Show();
}
private void button14_Click(object sender, EventArgs e)
{
StallionSuppyChain.Purchase_Order.POInquiry PO = new StallionSuppyChain.Purchase_Order.POInquiry();
PO.GetUserID(TxtUserID.Text);
PO.Show();
}
private void Transaction(string Action)
{
try
{
#region validation of required fields
if (comboBox6.SelectedValue.ToString() == "0")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (ListPOApprovedBy.Text == " -- Select-- ")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (comboBox5.Text == " -- Select-- ")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (comboBox10.Text == " -- Select-- ")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (comboBox9.Text == " -- Select-- ")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (txtDPRate.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (txtDPAmount.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (comboBox11.Text == " -- Select-- ")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
else if (txtRemarks.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
#endregion
string saveData = saveGridData();
if (saveData == "FAILED")
{
MessageBox.Show("Please validate values on grid.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
return;
}
if (txtForex.Text == "")
{
txtForex.Text = "0";
}
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TRAN_SAVE_PO";
cmd.Parameters.Add("@MRMID", SqlDbType.Int).Value = Convert.ToInt32(txtMRMID.Text);
cmd.Parameters.Add("@RequestNO", SqlDbType.VarChar, 20).Value = textBox1.Text.ToString();
cmd.Parameters.Add("@ProcurementID", SqlDbType.VarChar, 4).Value = comboBox6.SelectedValue.ToString();
cmd.Parameters.Add("@Status", SqlDbType.VarChar, 15).Value = Action;
cmd.Parameters.Add("@WorkerID", SqlDbType.Int).Value = Convert.ToInt32(ListPOApprovedBy.SelectedValue);
cmd.Parameters.Add("@SupplierID", SqlDbType.Int).Value = Convert.ToInt32(comboBox5.SelectedValue);
cmd.Parameters.Add("@PaymentTermsID", SqlDbType.Int).Value = Convert.ToInt32(comboBox10.SelectedValue);
cmd.Parameters.Add("@DeliveryTermsID", SqlDbType.Int).Value = Convert.ToInt32(comboBox9.SelectedValue);
cmd.Parameters.Add("@DP_Rate", SqlDbType.Float).Value = txtDPRate.Text;
cmd.Parameters.Add("@DP_Amount", SqlDbType.Float).Value = txtDPAmount.Text;
cmd.Parameters.Add("@Forex", SqlDbType.Float).Value = txtForex.Text;
cmd.Parameters.Add("@Local_Purchase", SqlDbType.Bit).Value = checkBox2.CheckState;
cmd.Parameters.Add("@Vat_Inclusive", SqlDbType.Bit).Value = checkBox3.CheckState;
cmd.Parameters.Add("@Forex_Date", SqlDbType.DateTime).Value = dateForexDate.Value;
cmd.Parameters.Add("@Currency_Code", SqlDbType.VarChar, 3).Value = comboBox11.SelectedValue.ToString();
cmd.Parameters.Add("@Remarks", SqlDbType.Text).Value = txtRemarks.Text;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
POInquiry poInquiry = new POInquiry();
poInquiry.Show();
this.Hide();
}
catch (Exception ex)
{
string errMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
MessageBox.Show(errMessage);
}
}