protected void LinkSelectClick(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
LinkButton btn = (LinkButton)sender;
Session["user_page_data_id"] = btn.CommandArgument;
string USER_DATA_ID = Convert.ToString(Session["user_page_data_id"]);
string makeSQL = " select BATCH_ID, BATCH_NO, FURNACES_ID, PARTY_ID, GRADE_ID, TO_CHAR(ENTRY_DATE,'dd/mm/yyyy') AS ENTRY_DATE, IS_ACTIVE from MF_PRODUCTION_BATCH_MASTER where BATCH_ID = '" + USER_DATA_ID + "'";
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++)
{
TextBatchID.Text = dt.Rows[i]["BATCH_ID"].ToString();
DropDownFurnacesID.Text = dt.Rows[i]["FURNACES_ID"].ToString();
TextBatchNumber.Text = dt.Rows[i]["BATCH_NO"].ToString();
DropDownSupplierID.Text = dt.Rows[i]["PARTY_ID"].ToString();
EntryDate.Text = dt.Rows[i]["ENTRY_DATE"].ToString();
CheckIsActive.Checked = Convert.ToBoolean(dt.Rows[i]["IS_ACTIVE"].ToString() == "Enable" ? true : false);
DataTable dtGradeID = new DataTable();
DataSet ds = new DataSet();
string makeGradeSQL = " SELECT MPG.GRADE_ID, MPG.GRADE_ID || ': ' || MI.ITEM_NAME AS ITEM_NAME FROM MF_PRODUCTION_GRADE_CUSTOMER MPGC LEFT JOIN MF_PRODUCTION_GRADE MPG ON MPG.GRADE_ID = MPGC.GRADE_ID LEFT JOIN MF_ITEM MI ON MI.ITEM_ID = MPG.ITEM_ID WHERE MPGC.PARTY_ID = '" + dt.Rows[i]["PARTY_ID"].ToString() + "' ";
ds = ExecuteBySqlString(makeGradeSQL);
dtGradeID = (DataTable)ds.Tables[0];
DropDownGradeID.DataSource = dtGradeID;
DropDownGradeID.DataValueField = "GRADE_ID";
DropDownGradeID.DataTextField = "ITEM_NAME";
DropDownGradeID.DataBind();
DropDownGradeID.Items.Insert(0, new ListItem("Select Grade Template", "0"));
DropDownGradeID.Text = dt.Rows[i]["GRADE_ID"].ToString();
}
conn.Close();
CheckItemSearch.Text = "";
BtnGradeDetails.Style["visibility"] = "show";
BtnBatchItemCheck.Style["visibility"] = "show";
DisplayGradeTempDetails();
alert_box.Visible = false;
DropDownFurnacesID.Enabled = false;
ItemDisplay(TextBatchNumber.Text, new EventArgs());
}
public void GetGradeList(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string USER_DATA_ID = DropDownSupplierID.Text;
DataTable dtGradeID = new DataTable();
DataSet ds = new DataSet();
string makeGradeSQL = " SELECT MPG.GRADE_ID, MPG.GRADE_ID || ': ' || MI.ITEM_NAME AS ITEM_NAME FROM MF_PRODUCTION_GRADE_CUSTOMER MPGC LEFT JOIN MF_PRODUCTION_GRADE MPG ON MPG.GRADE_ID = MPGC.GRADE_ID LEFT JOIN MF_ITEM MI ON MI.ITEM_ID = MPG.ITEM_ID WHERE MPGC.PARTY_ID = '" + USER_DATA_ID + "' AND MPG.IS_ACTIVE = 'Enable' ";
ds = ExecuteBySqlString(makeGradeSQL);
dtGradeID = (DataTable)ds.Tables[0];
DropDownGradeID.DataSource = dtGradeID;
DropDownGradeID.DataValueField = "GRADE_ID";
DropDownGradeID.DataTextField = "ITEM_NAME";
DropDownGradeID.DataBind();
DropDownGradeID.Items.Insert(0, new ListItem("Select Grade Template", "0"));
conn.Close();
alert_box.Visible = false;
}
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 dtItemID = new DataTable();
DataSet dsi = new DataSet();
string makeItemSQL = " SELECT ITEM_ID, ITEM_CODE || ' : ' || ITEM_NAME AS ITEM_FULL_NAME FROM MF_ITEM WHERE IS_ACTIVE = 'Enable' AND IS_SALES_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC";
dsi = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)dsi.Tables[0];
DropDownGradeID.DataSource = dtItemID;
DropDownGradeID.DataValueField = "ITEM_ID";
DropDownGradeID.DataTextField = "ITEM_FULL_NAME";
DropDownGradeID.DataBind();
DropDownGradeID.Items.Insert(0, new ListItem("Select Grade", "0"));
DataTable dtGradeTempID = new DataTable();
DataSet dsg = new DataSet();
string makeGradeTempSQL = " SELECT MPG.GRADE_ID, MPG.GRADE_ID || ' - ' || MI.ITEM_NAME AS ITEM_FULL_NAME FROM MF_PRODUCTION_GRADE MPG LEFT JOIN MF_ITEM MI ON MI.ITEM_ID = MPG.ITEM_ID WHERE MPG.IS_ACTIVE = 'Enable' ORDER BY MPG.GRADE_ID DESC";
dsg = ExecuteBySqlString(makeGradeTempSQL);
dtGradeTempID = (DataTable)dsg.Tables[0];
DropDownGradeTempID.DataSource = dtGradeTempID;
DropDownGradeTempID.DataValueField = "GRADE_ID";
DropDownGradeTempID.DataTextField = "ITEM_FULL_NAME";
DropDownGradeTempID.DataBind();
DropDownGradeTempID.Items.Insert(0, new ListItem("Select Grade Template", "0"));
DataTable dtSupplierID = new DataTable();
DataSet ds = new DataSet();
string makeSupplierSQL = " SELECT PARTY_ID, PARTY_ID || ' - ' || PARTY_NAME || ' - ' || PARTY_VAT_NO AS PARTY_NAME FROM MF_PARTY WHERE IS_ACTIVE = 'Enable' AND IS_PRODUCTION_ACTIVE = 'Enable' ORDER BY PARTY_NAME ASC";
ds = ExecuteBySqlString(makeSupplierSQL);
dtSupplierID = (DataTable)ds.Tables[0];
DropDownCustomerID.DataSource = dtSupplierID;
DropDownCustomerID.DataValueField = "PARTY_ID";
DropDownCustomerID.DataTextField = "PARTY_NAME";
DropDownCustomerID.DataBind();
DropDownCustomerID.Items.Insert(0, new ListItem("Select Customer", "0"));
TextGradeID.Enabled = false;
string get_batch_id = " select LAST_NUMBER from all_sequences where sequence_name = 'MF_PRODUCTION_GRADEID_SEQ'";
cmdu = new OracleCommand(get_batch_id, conn);
int GradeID = Convert.ToInt32(cmdu.ExecuteScalar());
GradeID = GradeID + 1;
TextGradeID.Text = String.Concat("GD-", GradeID.ToString().PadLeft(4, '0'));
string USER_DATA_ID = "";
ItemDisplay(USER_DATA_ID, new EventArgs());
Display();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
