protected void btnSave_Click(object sender, EventArgs e)
{
try
{
decimal?po_no = null;
decimal?mrv = null;
if (ddlPOList.SelectedIndex > 0)
{
po_no = decimal.Parse(ddlPOList.SelectedValue);
}
if (ddlMRVList.SelectedIndex > 0)
{
mrv = decimal.Parse(ddlMRVList.SelectedValue);
}
string rfi_id = WebTools.GetExpr("RFI_ID", "PIP_MAT_INSP_REQUEST", " WHERE RFI_NO = '" + txtAutoRFINo.Text.Trim() + "'");
if (rfi_id == null)
{
Master.show_error("Invalid RFI Number");
return;
}
dsMaterialBTableAdapters.VIEW_ADAPTER_MIRTableAdapter mir = new dsMaterialBTableAdapters.VIEW_ADAPTER_MIRTableAdapter();
mir.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtMIRNo.Text, txtInspDate.SelectedDate, txtRecvdDate.SelectedDate,
txtRcvBy.Text, po_no, mrv, decimal.Parse(ddlStoreList.SelectedValue), "N", txtRemarks.Text,
txtSRNNumber.Text, txtShipNumber.Text, txtShipMode.Text, txtInvoiceNo.Text, txtPackingList.Text, null,
decimal.Parse(ddlSubcon.SelectedValue), txtClientMIRNo.Text);
string sql = "UPDATE PRC_MAT_INSP SET RFI_ID = '" + rfi_id + "' WHERE MIR_NO = '" + txtMIRNo.Text + "'";
WebTools.ExeSql(sql);
Master.show_success("New MIR Number " + txtMIRNo.Text + " Created Successfully.");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
decimal?po_no = null;
decimal?mrv = null;
if (ddlPOList.SelectedIndex > 0)
{
po_no = decimal.Parse(ddlPOList.SelectedValue);
}
if (ddlPOList.SelectedValue == "-11")
{
//Create PO in PO Table
string sql = "INSERT INTO PIP_PO (PROJECT_ID, PO_NO, PO_DATE, PO_REV, MANUFACTURE, CREATE_BY) VALUES ('1', '";
sql += txtPOSearch.Text + "', '" + System.DateTime.Now.ToString("dd-MMM-yyyy") + "','0', '";
sql += txtSupplier.Text + "', '" + Session["USER_NAME"].ToString() + "')";
//Master.show_info(sql);
//return;
WebTools.ExeSql(sql);
po_no = decimal.Parse(WebTools.GetExpr("PO_ID", "PIP_PO", " WHERE PO_NO='" + txtPOSearch.Text + "'"));
}
if (ddlMRVList.SelectedIndex > 0)
{
mrv = decimal.Parse(ddlMRVList.SelectedValue);
}
string srn_no = "";
for (int i = 0; i < txtAutoSRNNo.Entries.Count; i++)
{
if (i == 0)
{
srn_no = txtAutoSRNNo.Entries[i].Text;
}
else
{
srn_no += "," + txtAutoSRNNo.Entries[i].Text;
}
}
string ship_mode;
if (rdbShipMode.SelectedIndex >= 0)
{
ship_mode = rdbShipMode.SelectedItem.Text;
}
else
{
ship_mode = "";
}
dsMaterialBTableAdapters.VIEW_ADAPTER_MIRTableAdapter mir = new dsMaterialBTableAdapters.VIEW_ADAPTER_MIRTableAdapter();
mir.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtMIRNo.Text, txtInspDate.SelectedDate, txtRecvdDate.SelectedDate,
txtRcvBy.Text, po_no, mrv, decimal.Parse(ddlStoreList.SelectedValue), "N", txtRemarks.Text,
srn_no, txtShipNumber.Text, ship_mode, txtInvoiceNo.Text, txtPackingList.Text, txtAWBBLTWB.Text,
decimal.Parse(ddlSubcon.SelectedValue));
Master.show_success("New MIR Number " + txtMIRNo.Text + " Created Successfully.");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
