public void Display()
{
if (IS_VIEW_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " select * from WP_PARTY ORDER BY UPDATE_DATE desc, CREATE_DATE desc";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
GridView4D.DataSource = dt;
GridView4D.DataKeyNames = new string[] { "PARTY_ID" };
GridView4D.DataBind();
conn.Close();
TextSupplierName.Focus();
DisplayAddress();
}
else
{
// Response.Redirect("~/PagePermissionError.aspx");
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
if (IS_DELETE_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int USER_DATA_ID = Convert.ToInt32(TextSupplierID.Text);
string delete_user_page = " delete from WP_PARTY where PARTY_ID = '" + USER_DATA_ID + "'";
cmdi = new OracleCommand(delete_user_page, conn);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Party Delete Successfully"));
alert_box.Attributes.Add("class", "alert alert-danger alert-dismissible");
clearText();
Display();
TextSupplierName.Focus();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
public void BtnAdd_Click(object sender, EventArgs e)
{
try
{
if (IS_ADD_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
string get_supplier_id = "select WP_PARTY_ID_SEQ.nextval from dual";
cmdu = new OracleCommand(get_supplier_id, conn);
int newSupplierID = Int16.Parse(cmdu.ExecuteScalar().ToString());
string ISActive = CheckIsActive.Checked ? "Enable" : "Disable";
string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string insert_user = "******";
cmdi = new OracleCommand(insert_user, conn);
OracleParameter[] objPrm = new OracleParameter[10];
objPrm[0] = cmdi.Parameters.Add("NoSupplierID", newSupplierID);
objPrm[1] = cmdi.Parameters.Add("TextSupplierName", TextSupplierName.Text);
objPrm[2] = cmdi.Parameters.Add("TextSupArabicName", TextSupArabicName.Text);
objPrm[3] = cmdi.Parameters.Add("TextSupVatNo", TextSupVatNo.Text);
objPrm[4] = cmdi.Parameters.Add("TextSup_Add_1", TextSup_Add_1.Text);
objPrm[5] = cmdi.Parameters.Add("TextSup_Add_2", TextSup_Add_2.Text);
objPrm[6] = cmdi.Parameters.Add("TextContactNo", TextContactNo.Text);
objPrm[7] = cmdi.Parameters.Add("TextIsActive", ISActive);
objPrm[8] = cmdi.Parameters.Add("u_date", u_date);
objPrm[9] = cmdi.Parameters.Add("NoCuserID", userID);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Insert New Party Data Successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
TextSupplierName.Focus();
Display();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
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 dtPartyID = new DataTable();
DataSet dsp = new DataSet();
string makePartySQL = " SELECT * FROM HR_COUNTRIES ORDER BY COUNTRY_NAME ASC";
dsp = ExecuteBySqlString(makePartySQL);
dtPartyID = (DataTable)dsp.Tables[0];
DropDownCountryID.DataSource = dtPartyID;
DropDownCountryID.DataValueField = "COUNTRY_ID";
DropDownCountryID.DataTextField = "COUNTRY_NAME";
DropDownCountryID.DataBind();
DropDownCountryID.Items.Insert(0, new ListItem("Select Country Name", "0"));
TextSupplierName.Focus();
Display();
DisplayAddress();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
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)
{
TextSupplierName.Focus();
Display();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
if (IS_EDIT_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
int USER_DATA_ID = Convert.ToInt32(TextSupplierID.Text);
string ISActive = CheckIsActive.Checked ? "Enable" : "Disable";
string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string update_user = "******";
cmdi = new OracleCommand(update_user, conn);
OracleParameter[] objPrm = new OracleParameter[10];
objPrm[0] = cmdi.Parameters.Add("TextSupplierName", TextSupplierName.Text);
objPrm[1] = cmdi.Parameters.Add("TextSupArabicName", TextSupArabicName.Text);
objPrm[2] = cmdi.Parameters.Add("TextSupVatNo", TextSupVatNo.Text);
objPrm[3] = cmdi.Parameters.Add("TextSup_Add_1", TextSup_Add_1.Text);
objPrm[4] = cmdi.Parameters.Add("TextSup_Add_2", TextSup_Add_2.Text);
objPrm[5] = cmdi.Parameters.Add("TextContactNo", TextContactNo.Text);
objPrm[6] = cmdi.Parameters.Add("u_date", u_date);
objPrm[7] = cmdi.Parameters.Add("NoSupplierID", USER_DATA_ID);
objPrm[8] = cmdi.Parameters.Add("NoC_USER_ID", userID);
objPrm[9] = cmdi.Parameters.Add("TextIsActive", ISActive);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Party Data Update Successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
Display();
TextSupplierName.Focus();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
protected void linkSelectClick(object sender, EventArgs e)
{
try{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
LinkButton btn = (LinkButton)sender;
Session["user_page_data_id"] = btn.CommandArgument;
int USER_DATA_ID = Convert.ToInt32(Session["user_page_data_id"]);
string makeSQL = " select * from WP_PARTY where PARTY_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++)
{
TextSupplierID.Text = dt.Rows[i]["PARTY_ID"].ToString();
TextSupplierName.Text = dt.Rows[i]["PARTY_NAME"].ToString();
TextSupArabicName.Text = dt.Rows[i]["PARTY_ARABIC_NAME"].ToString();
TextSupVatNo.Text = dt.Rows[i]["PARTY_VAT_NO"].ToString();
TextSup_Add_1.Text = dt.Rows[i]["PARTY_ADD_1"].ToString();
TextSup_Add_2.Text = dt.Rows[i]["PARTY_ADD_2"].ToString();
TextContactNo.Text = dt.Rows[i]["CONTACT_NO"].ToString();
CheckIsActive.Checked = Convert.ToBoolean(dt.Rows[i]["IS_ACTIVE"].ToString() == "Enable" ? true : false);
}
conn.Close();
Display();
TextSupplierName.Focus();
CheckSupplierName.Text = "";
alert_box.Visible = false;
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
public void Display()
{
if (IS_VIEW_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
DataTable dtUserTypeID = new DataTable();
DataSet ds = new DataSet();
string makeSQL = "";
if (txtSearchUserRole.Text == "")
{
makeSQL = " select * from PF_PARTY ORDER BY UPDATE_DATE desc, CREATE_DATE desc";
}
else
{
makeSQL = " select * from PF_PARTY where PARTY_ID like '" + txtSearchUserRole.Text + "%' or PARTY_NAME like '" + txtSearchUserRole.Text + "%' or PARTY_ARABIC_NAME like '" + txtSearchUserRole.Text + "%' or PARTY_VAT_NO like '" + txtSearchUserRole.Text + "%' or IS_ACTIVE like '" + txtSearchUserRole.Text + "%' ORDER BY UPDATE_DATE desc, CREATE_DATE desc";
alert_box.Visible = false;
}
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataKeyNames = new string[] { "PARTY_ID" };
GridView1.DataBind();
conn.Close();
//alert_box.Visible = false;
TextSupplierName.Focus();
}
else
{
// Response.Redirect("~/PagePermissionError.aspx");
}
}
public void TextSupplierName_TextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TextSupplierName.Text))
{
alert_box.Visible = false;
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from WP_PARTY where PARTY_NAME = '" + TextSupplierName.Text + "'";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
CheckSupplierName.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> Party name is already entry</label>";
CheckSupplierName.ForeColor = System.Drawing.Color.Red;
TextSupplierName.Focus();
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
}
else
{
CheckSupplierName.Text = "<label class='control-label'><i class='fa fa fa-check'></i> Party name is available</label>";
CheckSupplierName.ForeColor = System.Drawing.Color.Green;
CheckIsActive.Focus();
BtnAdd.Attributes.Add("aria-disabled", "true");
BtnAdd.Attributes.Add("class", "btn btn-primary active");
}
}
else
{
CheckSupplierName.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Party name is not blank</label>";
CheckSupplierName.ForeColor = System.Drawing.Color.Red;
TextSupplierName.Focus();
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
if (IS_EDIT_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
int USER_DATA_ID = Convert.ToInt32(TextSupplierID.Text);
string ISActive = CheckIsActive.Checked ? "Enable" : "Disable";
string IsPurchaseActive = CheckIsPurchaseActive.Checked ? "Enable" : "Disable";
string IsSalesActive = CheckIsSalesActive.Checked ? "Enable" : "Disable";
string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string update_user = "******";
cmdi = new OracleCommand(update_user, conn);
OracleParameter[] objPrm = new OracleParameter[12];
objPrm[0] = cmdi.Parameters.Add("TextSupplierName", TextSupplierName.Text);
objPrm[1] = cmdi.Parameters.Add("TextSupArabicName", TextSupArabicName.Text);
objPrm[2] = cmdi.Parameters.Add("TextSupVatNo", TextSupVatNo.Text);
objPrm[3] = cmdi.Parameters.Add("TextSup_Add_1", TextSup_Add_1.Text);
objPrm[4] = cmdi.Parameters.Add("TextSup_Add_2", TextSup_Add_2.Text);
objPrm[5] = cmdi.Parameters.Add("TextContactNo", TextContactNo.Text);
objPrm[6] = cmdi.Parameters.Add("u_date", u_date);
objPrm[7] = cmdi.Parameters.Add("NoSupplierID", USER_DATA_ID);
objPrm[8] = cmdi.Parameters.Add("NoC_USER_ID", userID);
objPrm[9] = cmdi.Parameters.Add("TextIsActive", ISActive);
objPrm[10] = cmdi.Parameters.Add("TextIsPurchaseActive", IsPurchaseActive);
objPrm[11] = cmdi.Parameters.Add("TextIsSalesActive", IsSalesActive);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
string delete_user = "******" + Convert.ToInt32(TextSupplierID.Text) + "'";
cmdi = new OracleCommand(delete_user, conn);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
foreach (ListItem li in DropDownRepresentativeID.Items)
{
if (li.Selected == true)
{
string RepresentativeID = li.Value;
string insert_pur_rep = " insert into MS_PARTY_REPRESENTATIVE (PARTY_ID, REPRESENTATIVE_ID) VALUES ( :NoPartyID, :NoRepresentativeID) ";
cmdi = new OracleCommand(insert_pur_rep, conn);
OracleParameter[] objPr = new OracleParameter[3];
objPr[0] = cmdi.Parameters.Add("NoPartyID", Convert.ToInt32(TextSupplierID.Text));
objPr[1] = cmdi.Parameters.Add("NoRepresentativeID", RepresentativeID);
cmdi.ExecuteNonQuery();
}
}
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Party Data Update Successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
Display();
TextSupplierName.Focus();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
