protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtCurrencyRateID = new DataTable();
DataSet drs = new DataSet();
string makeRateSQL = " SELECT NCR.CURRENCY_RATE_ID || '-' || NCR.EXCHANGE_RATE AS CURRENCY_RATE_ID, NCS.CURRENCY_SYMBOL || ' ' || NCS.CURRENCY_NAME || ' - ' || NCT.CURRENCY_SYMBOL || ' ' || NCT.CURRENCY_NAME || ', Rate - ' || NCR.EXCHANGE_RATE AS CURRENCY_NAME FROM NRC_CURRENCY_RATE NCR LEFT JOIN NRC_CURRENCY NCS ON NCS.CURRENCY_ID = NCR.SOURCE_CURRENCY_ID LEFT JOIN NRC_CURRENCY NCT ON NCT.CURRENCY_ID = NCR.TARGET_CURRENCY_ID WHERE NCR.IS_ACTIVE = 'Enable' ORDER BY NCR.CURRENCY_RATE_ID ASC ";
drs = ExecuteBySqlString(makeRateSQL);
dtCurrencyRateID = (DataTable)drs.Tables[0];
DropDownCurrencyRateID.DataSource = dtCurrencyRateID;
DropDownCurrencyRateID.DataValueField = "CURRENCY_RATE_ID";
DropDownCurrencyRateID.DataTextField = "CURRENCY_NAME";
DropDownCurrencyRateID.DataBind();
DropDownCurrencyRateID.Items.Insert(0, new ListItem("Select Currency Conversion", "0"));
DataTable dtSlipNo = new DataTable();
DataSet dss = new DataSet();
string makePageSQL = " SELECT PEWC.WB_SLIP_NO, PEWC.CONTAINER_NO || ' - ' || PEWC.WB_SLIP_NO || '' || ', Item WT(WB) -' || TO_CHAR(PEWC.ITEM_WEIGHT_WB, '999,999,999') AS PARTY_NAME FROM MS_EXPORT_WBSLIP_CON PEWC WHERE PEWC.EXPORT_INVOICE_NO IS NULL AND PEWC.IS_ACTIVE_PRICING IS NULL ORDER BY PEWC.CONTAINER_NO, PEWC.WB_SLIP_NO ASC";
dss = ExecuteBySqlString(makePageSQL);
dtSlipNo = (DataTable)dss.Tables[0];
DropDownWpSlipNoEx.DataSource = dtSlipNo;
DropDownWpSlipNoEx.DataValueField = "WB_SLIP_NO";
DropDownWpSlipNoEx.DataTextField = "PARTY_NAME";
DropDownWpSlipNoEx.DataBind();
DropDownWpSlipNoEx.Items.Insert(0, new ListItem("Select Weight / Container", "0"));
// TextExportInvoiceNo.Enabled = false;
Display();
TextTotalQty.Attributes.Add("readonly", "readonly");
TextTotalAmountEx.Attributes.Add("readonly", "readonly");
TextItemCurrencyAmount.Attributes.Add("readonly", "readonly");
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
protected void LinkSelectClick(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
LinkButton btn = (LinkButton)sender;
Session["user_data_id"] = btn.CommandArgument;
// string[] USER_DATA_ID = Session["user_data_id"].ToString().Split('-');
string USER_DATA_ID = Session["user_data_id"].ToString();
DataTable dtSlipNo = new DataTable();
DataSet dss = new DataSet();
string makePageSQL = " SELECT PEWC.WB_SLIP_NO, PEWC.CONTAINER_NO || ' - ' || PEWC.WB_SLIP_NO || '' || ', Item WT(WB) -' || TO_CHAR(PEWC.ITEM_WEIGHT_WB, '999,999,999') AS PARTY_NAME FROM MS_EXPORT_WBSLIP_CON PEWC WHERE PEWC.EXPORT_INVOICE_NO IS NULL ORDER BY PEWC.WB_SLIP_NO ASC ";
dss = ExecuteBySqlString(makePageSQL);
dtSlipNo = (DataTable)dss.Tables[0];
DropDownWpSlipNoEx.DataSource = dtSlipNo;
DropDownWpSlipNoEx.DataValueField = "WB_SLIP_NO";
DropDownWpSlipNoEx.DataTextField = "PARTY_NAME";
DropDownWpSlipNoEx.DataBind();
DropDownWpSlipNoEx.Items.Insert(0, new ListItem("Select Weight / Container", "0"));
string makeSQL = " SELECT PEWCI.EXP_WBCON_ITEM_ID, PEWCI.WB_SLIP_NO, PEWCI.ITEM_ID, PEWCI.ITEM_SALES_ID, PEWCI.MAT_PRICE_PER_MT, PEWCI.MATERIAL_AMOUNT, PEWCI.ITEM_WEIGHT, NCR.CURRENCY_RATE_ID || '-' || NCR.EXCHANGE_RATE AS CURRENCY_RATE_ID, PEWCI.CURRENCY_RATE, PEWCI.MATERIAL_CONVERSION_AMOUNT, PEWCI.IS_ACTIVE_PRICING, PEWCI.UPDATE_DATE_PRICING, PEWCI.U_USER_ID_PRICING FROM MS_EXPORT_WBSLIP_CON_ITEM PEWCI LEFT JOIN NRC_CURRENCY_RATE NCR ON NCR.CURRENCY_RATE_ID = PEWCI.CURRENCY_RATE_ID WHERE PEWCI.EXP_WBCON_ITEM_ID = '" + USER_DATA_ID + "'";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
ds = new DataTable();
oradata.Fill(ds);
RowCount = ds.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
DataTable dtItemID = new DataTable();
DataSet dsi = new DataSet();
string makeItemSQL = " SELECT WEECI.EXP_WBCON_ITEM_ID || '-' || WEECI.ITEM_WEIGHT || '-' || WI.ITEM_ID AS EXP_WBCON_ITEM_ID, WEECI.WB_SLIP_NO, WI.ITEM_NAME || ' - ' || WI.ITEM_CODE || '- Item Weight: ' || WEECI.ITEM_WEIGHT || ', No Of Pack: ' || WEECI.NUMBER_OF_PACK AS ITEM_NAME FROM MS_EXPORT_WBSLIP_CON_ITEM WEECI LEFT JOIN MF_ITEM WI ON WI.ITEM_ID = WEECI.ITEM_ID WHERE WEECI.WB_SLIP_NO = '" + ds.Rows[i]["WB_SLIP_NO"].ToString() + "' ";
dsi = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)dsi.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EXP_WBCON_ITEM_ID";
DropDownItemID.DataTextField = "ITEM_NAME";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Please Select Item", "0"));
DataTable dtSalesItemID = new DataTable();
DataSet dssi = new DataSet();
string makeSalesItemSQL = " SELECT ITEM_SALES_ID, ITEM_SALES_DESCRIPTION, ITEM_ID FROM MS_SALES_ITEM WHERE ITEM_ID = '" + ds.Rows[i]["ITEM_ID"].ToString() + "' AND IS_ACTIVE = 'Enable' ";
dssi = ExecuteBySqlString(makeSalesItemSQL);
dtSalesItemID = (DataTable)dssi.Tables[0];
DropDownSalesItemID.DataSource = dtSalesItemID;
DropDownSalesItemID.DataValueField = "ITEM_SALES_ID";
DropDownSalesItemID.DataTextField = "ITEM_SALES_DESCRIPTION";
DropDownSalesItemID.DataBind();
DropDownSalesItemID.Items.Insert(0, new ListItem("Please Select Sales Item Name", "0"));
// DropDownWpSlipNoEx.Text = ds.Rows[i]["WB_SLIP_NO"].ToString() + "-"+ ds.Rows[i]["ITEM_WEIGHT"].ToString();
DropDownWpSlipNoEx.Text = ds.Rows[i]["WB_SLIP_NO"].ToString();
DropDownItemID.Text = ds.Rows[i]["EXP_WBCON_ITEM_ID"].ToString() + "-" + ds.Rows[i]["ITEM_WEIGHT"].ToString() + "-" + ds.Rows[i]["ITEM_ID"].ToString();
DropDownSalesItemID.Text = ds.Rows[i]["ITEM_SALES_ID"].ToString();
double TotalQty = Convert.ToDouble(ds.Rows[i]["ITEM_WEIGHT"].ToString()) / 1000;
TextTotalQty.Text = decimal.Parse(TotalQty.ToString()).ToString("0.000");
TextPricePerMt.Text = decimal.Parse(ds.Rows[i]["MAT_PRICE_PER_MT"].ToString()).ToString(".00");
TextTotalAmountEx.Text = decimal.Parse(ds.Rows[i]["MATERIAL_AMOUNT"].ToString()).ToString(".00");
DropDownCurrencyRateID.Text = ds.Rows[i]["CURRENCY_RATE_ID"].ToString();
TextItemCurrencyAmount.Text = decimal.Parse(ds.Rows[i]["MATERIAL_CONVERSION_AMOUNT"].ToString()).ToString(".00");
CheckIsActive.Checked = Convert.ToBoolean(ds.Rows[i]["IS_ACTIVE_PRICING"].ToString() == "Enable" ? true : false);
}
Display();
conn.Close();
alert_box.Visible = false;
DropDownWpSlipNoEx.Enabled = false;
// DropDownItemID.Enabled = false;
BtnUpdate.Attributes.Add("aria-disabled", "true");
BtnUpdate.Attributes.Add("class", "btn btn-success active");
}
