protected void DropdownCompanySelectedIndexChanged(object sender, EventArgs e)
{
StockInManager item = new StockInManager();
int companyid = Convert.ToInt32(DropDownCompanyList.SelectedItem.Value);
DropDownItemList.DataSource = item.GetAllitem(companyid);
DropDownItemList.DataTextField = "ItemName";
DropDownItemList.DataValueField = "ItemId";
DropDownItemList.DataBind();
DropDownItemList.Items.Insert(0, new ListItem("Select", "0"));
}
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, NUPP.IS_REPORT_ACTIVE, NUPP.IS_PRINT_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();
IS_REPORT_ACTIVE = dt.Rows[i]["IS_REPORT_ACTIVE"].ToString();
IS_PRINT_ACTIVE = dt.Rows[i]["IS_PRINT_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtSupplierID = new DataTable();
DataSet ds = new DataSet();
string makeSupplierSQL = " SELECT PARTY_ID, PARTY_ID || ' - ' || PARTY_NAME || ' - ' || PARTY_VAT_NO AS PARTY_NAME FROM WP_PARTY WHERE IS_ACTIVE = 'Enable' ORDER BY PARTY_NAME ASC";
ds = ExecuteBySqlString(makeSupplierSQL);
dtSupplierID = (DataTable)ds.Tables[0];
DropDownSupplierID.DataSource = dtSupplierID;
DropDownSupplierID.DataValueField = "PARTY_ID";
DropDownSupplierID.DataTextField = "PARTY_NAME";
DropDownSupplierID.DataBind();
DropDownSupplierID.Items.Insert(0, new ListItem("Select Supplier", "0"));
DropDownSupplierID2.DataSource = dtSupplierID;
DropDownSupplierID2.DataValueField = "PARTY_ID";
DropDownSupplierID2.DataTextField = "PARTY_NAME";
DropDownSupplierID2.DataBind();
DropDownSupplierID2.Items.Insert(0, new ListItem("Select Supplier", "0"));
DataTable dtItemID = new DataTable();
DataSet dsi = new DataSet();
string makeDropDownItemSQL = " SELECT ITEM_ID, ITEM_NAME || ' - ' || ITEM_CODE AS ITEM_NAME FROM WP_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC";
dsi = ExecuteBySqlString(makeDropDownItemSQL);
dtItemID = (DataTable)dsi.Tables[0];
DropDownItemList.DataSource = dtItemID;
DropDownItemList.DataValueField = "ITEM_ID";
DropDownItemList.DataTextField = "ITEM_NAME";
DropDownItemList.DataBind();
DropDownItemList.Items.Insert(0, new ListItem("All Item", "0"));
DataTable dtPgeID = new DataTable();
DataSet dsp = new DataSet();
string makeDropDownPgeSQL = " SELECT * FROM NRC_VAT WHERE IS_ACTIVE = 'Enable' ORDER BY VAT_ID ASC";
dsp = ExecuteBySqlString(makeDropDownPgeSQL);
dtPgeID = (DataTable)dsp.Tables[0];
DropDownVatID.DataSource = dtPgeID;
DropDownVatID.DataValueField = "VAT_ID";
DropDownVatID.DataTextField = "VAT_PERCENT";
DropDownVatID.DataBind();
// VatPercent.Visible = false;
// TextItemAmountWP.Attributes.Add("readonly", "readonly");
// TextItemVatAmountWP.Enabled = false;
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
static public void LoadUserList()
{
UserList = new DropDownItemList();
DaUser daUser = new DaUser(DbConnection);
DnUser list = daUser.Fill("Id>1", "UserID", 0, true);
UserList = new DropDownItemList(list.Count);
UserList.Add(1, string.Empty, string.Empty);
foreach (DdUser dd in list)
UserList.Add(dd.Id, dd.UserID, dd.UserID);
}
