private void btnProductAttr_Click(object sender, EventArgs e)
{
var productAttr = new List <ProductAttributeModel>();
using (ItemMasterLookUp formTask = new ItemMasterLookUp())
{
string productMasterFile = "PMF";
formTask.Test("", productMasterFile);
formTask.GetUserID("1");
var result = formTask.ShowDialog();
if (result == DialogResult.OK)
{
productAttr = formTask.ProductAttributes;
productAttributes.AddRange(productAttr);
}
foreach (ProductAttributeModel pa in productAttr)
{
dgvProductAttributes.Rows.Add("Remove", 0, pa.ItemCode, pa.Quantity, pa.Category1, pa.Category2, pa.Category3, pa.ItemDescription1, pa.ItemDescription2, pa.ItemSpecs1, pa.ItemSpecs2, pa.UOM, pa.CostCode);
}
}
}
private void TranSaveHeader(int processID, string Action)
{
string StringReturn = "";
string status = "";
if (Action == "SAVE" || Action == "ADDNEW")
{
status = "Open";
}
if (Action == "SUBMIT")
{
status = "Submitted";
}
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TRAN_SAVEMaterialRequest";
cmd.Parameters.Add("@ProcurementID", SqlDbType.VarChar).Value = cboCategoryType.SelectedValue.ToString();
cmd.Parameters.Add("@ProjectID", SqlDbType.Int).Value = Convert.ToInt32(cboProjectCode.SelectedValue.ToString());
cmd.Parameters.Add("@status", SqlDbType.VarChar, 15).Value = status;
cmd.Parameters.Add("@ForPurchase", SqlDbType.Bit).Value = ckpurchase.CheckState;
cmd.Parameters.Add("@DateNeeded", SqlDbType.DateTime).Value = Convert.ToDateTime(dateTimePicker4.Value.ToString());
cmd.Parameters.Add("@Requestedby", SqlDbType.Int).Value = Convert.ToInt32(cborquestedby.SelectedValue.ToString());
cmd.Parameters.Add("@Recomendedby", SqlDbType.Int).Value = Convert.ToInt32(cboRecomendedby.SelectedValue.ToString());
cmd.Parameters.Add("@DelivedTo", SqlDbType.Int).Value = Convert.ToInt32(cboDeleveredto.SelectedValue.ToString());
cmd.Parameters.Add("@UserCreated", SqlDbType.Int).Value = Convert.ToInt32(TxtUserID.Text);
cmd.Parameters.Add("@Approvedby", SqlDbType.Int).Value = Convert.ToInt32(cboApproveby.SelectedValue.ToString());
cmd.Parameters.Add("@MRMNo", SqlDbType.VarChar, 50).Value = TXTMRMNO.Text;
cmd.Parameters.Add("@ProcessID", SqlDbType.Int).Value = processID;
cmd.Connection = con;
try
{
con.Open();
StringReturn = cmd.ExecuteScalar().ToString();
if (Action == "SAVE" || Action == "SUBMIT")
{
MessageBox.Show("Record Saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
btnSave.Enabled = false;
MaterialRequestIquiry formTask2 = new MaterialRequestIquiry();
formTask2.GetUserID(TxtUserID.Text);
this.Dispose();
formTask2.Show();
}
ItemMasterLookUp formTask = new ItemMasterLookUp();
if (Action == "ADDNEW")
{
formTask.Test(StringReturn, "MRM");
formTask.GetUserID(TxtUserID.Text);
this.Dispose();
formTask.Show();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
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();
}
}
