protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Login.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
compid = Session["comid"].ToString();
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
Pagecontrol.dypcontrol(Page, page);
ViewState["sortOrder"] = "";
lblCompany.Text = Session["Cname"].ToString();
rdlist1_SelectedIndexChanged(sender, e);
rdipright_SelectedIndexChanged(sender, e);
DataTable dr = new DataTable();
dr = ClsIp.SelctIpGridfill(ddlfilterbus.SelectedValue, 1, ddlfilteruser.SelectedValue);
if (dr.Rows.Count == 0)
{
dr = ClsIp.SelctIpGridfill("0", 0, "0");
}
if (dr.Rows.Count > 0)
{
rdlist1.SelectedIndex = 0;
rdipright.Items[0].Text = "List of IP Addresses Allowed for Any Users";
rdipright.Items[1].Text = "List of IP Addresses Allowed for Specific Users";
rdipright.SelectedIndex = 0;
rdlist1_SelectedIndexChanged(sender, e);
rdipright_SelectedIndexChanged(sender, e);
}
else
{
rdlist1_SelectedIndexChanged(sender, e);
}
FillGridView1();
}
if (IsPostBack)
{
dynip = HttpContext.Current.Request.UserHostName;
}
}
protected void btnadtolist_Click(object sender, EventArgs e)
{
int inc1 = 0;
DataTable dsp1 = ClsIp.SelctIpControlMastertblId();
if (dsp1.Rows.Count > 0)
{
if (rdipright.SelectedIndex == 0)
{
string str45 = "Select IpControldetailtbl.* from IpControlMastertbl inner join IpControldetailtbl on IpControldetailtbl.IpcontrolId= IpControlMastertbl.IpcontrolId where CID='" + Session["comid"].ToString() + "' and Ipaddress='" + dynip + "' and IpControldetailtbl.Cidwise='True' and Userwise='False' ";
SqlCommand cmd45 = new SqlCommand(str45, con);
SqlDataAdapter da = new SqlDataAdapter(cmd45);
DataTable ds = new DataTable();
da.Fill(ds);
if (ds.Rows.Count > 0)
{
statuslable.Visible = true;
statuslable.Text = "Record already exist";
}
else
{
inc1 = ClsIp.InsertIpAddress(Convert.ToInt32(dsp1.Rows[0]["IpcontrolId"]), Convert.ToBoolean(1), Convert.ToBoolean(0), "0", dynip);
statuslable.Visible = true;
statuslable.Text = "Record inserted successfully";
}
}
else
{
string str45 = "Select IpControldetailtbl.* from IpControlMastertbl inner join IpControldetailtbl on IpControldetailtbl.IpcontrolId= IpControlMastertbl.IpcontrolId where CID='" + Session["comid"].ToString() + "' and Ipaddress='" + dynip + "' and IpControldetailtbl.Cidwise='False' and Userwise='True' and IpControldetailtbl.UserId='" + ddluser.SelectedValue + "' ";
SqlCommand cmd45 = new SqlCommand(str45, con);
SqlDataAdapter da = new SqlDataAdapter(cmd45);
DataTable ds = new DataTable();
da.Fill(ds);
if (ds.Rows.Count > 0)
{
statuslable.Visible = true;
statuslable.Text = "Record already exist";
}
else
{
inc1 = ClsIp.InsertIpAddress(Convert.ToInt32(dsp1.Rows[0]["IpcontrolId"]), Convert.ToBoolean(0), Convert.ToBoolean(1), ddluser.SelectedValue, dynip);
statuslable.Visible = true;
statuslable.Text = "Record inserted successfully";
}
}
FillGridView1();
}
}
protected void ddlbusiness_SelectedIndexChanged(object sender, EventArgs e)
{
ddluser.Items.Clear();
DataTable ds = ClsIp.SelectUserbywhid(ddlbusiness.SelectedValue);
if (ds.Rows.Count > 0)
{
ddluser.DataSource = ds;
ddluser.DataValueField = "UserId";
ddluser.DataTextField = "Username";
ddluser.DataBind();
}
ddluser.Items.Insert(0, "Select");
ddluser.Items[0].Value = "0";
}
protected void rdlist1_SelectedIndexChanged(object sender, EventArgs e)
{
if (rdlist1.SelectedIndex == 0)
{
int ins = ClsIp.InsertIpControlMastertbl(Convert.ToBoolean(1));
ViewState["ipallowip"] = ins.ToString();
pnlbtn.Visible = true;
pnlusercid.Visible = true;
}
else if (rdlist1.SelectedIndex == 1)
{
int ins = ClsIp.InsertIpControlMastertbl(Convert.ToBoolean(0));
pnlbtn.Visible = false;
pnlusercid.Visible = false;
}
}
protected void grduser_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Get the ID of the record to be deleted
string id = grduser.DataKeys[e.RowIndex].Value.ToString();
int axd = ClsIp.DeleteIpAddress(Convert.ToInt32(id));
if (axd > 0)
{
statuslable.Visible = true;
statuslable.Text = "Record deleted successfully";
FillGridView1();
}
else
{
statuslable.Visible = true;
statuslable.Text = "Sorry,record not deleted";
}
}
protected void ddlfilterbus_SelectedIndexChanged(object sender, EventArgs e)
{
lblbusiness.Visible = true;
lblbusiness.Text = "Business : " + ddlfilterbus.SelectedItem.Text;
ddlfilteruser.Items.Clear();
DataTable ds = ClsIp.SelectUserbywhid(ddlfilterbus.SelectedValue);
if (ds.Rows.Count > 0)
{
ddlfilteruser.DataSource = ds;
ddlfilteruser.DataValueField = "UserId";
ddlfilteruser.DataTextField = "Username";
ddlfilteruser.DataBind();
}
ddlfilteruser.Items.Insert(0, "All");
ddlfilteruser.Items[0].Value = "0";
lbluserp.Text = ddlfilteruser.SelectedItem.Text;
FillGridView1();
}
protected void FillGridView1()
{
if (rdipright.SelectedIndex == 0)
{
alluseripcheck();
}
else
{
specificuseripcheck();
}
DataTable dr = new DataTable();
if (rdipright.SelectedIndex == 1)
{
dr = ClsIp.SelctIpGridfill(ddlfilterbus.SelectedValue, 1, ddlfilteruser.SelectedValue);
Label5.Visible = true;
grduser.Columns[0].Visible = true;
grduser.Columns[1].Visible = true;
grduser.Columns[2].Visible = true;
}
else if (rdipright.SelectedIndex == 0)
{
dr = ClsIp.SelctIpGridfill("0", 0, "0");
Label5.Visible = false;
grduser.Columns[0].Visible = false;
grduser.Columns[1].Visible = false;
grduser.Columns[2].Visible = false;
}
grduser.DataSource = dr;
if (dr.Rows.Count == 0)
{
btnadtolist.Visible = true;
// lblalready.Visible = false;
// pnlcurrentip.Visible = false;
}
p = 0;
for (int i = 0; i < dr.Rows.Count; i++)
{
if (p == 0)
{
if (dr.Rows[i]["IpAddress"].ToString() == dynip)
{
btnadtolist.Visible = false;
//lblalready.Visible = true;
// pnlcurrentip.Visible = true;
p = 1;
}
else
{
btnadtolist.Visible = true;
// lblalready.Visible = false;
// pnlcurrentip.Visible = false;
}
}
}
DataView myDataView = new DataView();
myDataView = dr.DefaultView;
if (hdnsortExp.Value != string.Empty)
{
myDataView.Sort = string.Format("{0} {1}", hdnsortExp.Value, hdnsortDir.Value);
}
grduser.DataBind();
//if (grduser.Rows.Count > 0)
//{
// pnlusergrid.Visible = true;
// pnlms.Visible = false;
//}
//else
//{
// pnlusergrid.Visible = false;
// pnlms.Visible = true;
//}
}
protected void btnaddn0_Click(object sender, EventArgs e)
{
int flag = ret(txtIpAddress.Text);
int flag1 = ret(txtip1.Text);
int flag2 = ret(txtip2.Text);
int flag3 = ret(txtip3.Text);
int inc = 0;
if (flag == 0 && flag1 == 0 && flag2 == 0 && flag3 == 0)
{
string Ipaddd = txtIpAddress.Text + "." + txtip1.Text + "." + txtip2.Text + "." + txtip3.Text;
DataTable dsp = ClsIp.SelctIpControlMastertblId();
if (dsp.Rows.Count > 0)
{
if (rdipright.SelectedIndex == 0)
{
inc = ClsIp.InsertIpAddress(Convert.ToInt32(dsp.Rows[0]["IpcontrolId"]), Convert.ToBoolean(1), Convert.ToBoolean(0), "0", Ipaddd);
}
else if (rdipright.SelectedIndex == 1)
{
inc = ClsIp.InsertIpAddress(Convert.ToInt32(dsp.Rows[0]["IpcontrolId"]), Convert.ToBoolean(0), Convert.ToBoolean(1), ddluser.SelectedValue, Ipaddd);
}
if (inc > 0)
{
SqlDataAdapter daq = new SqlDataAdapter("select * from TBLUserLoginIpRestrictionPreference where userid='" + ddluser.SelectedValue + "' and compid='" + Session["Comid"] + "'", con);
DataTable dys = new DataTable();
daq.Fill(dys);
if (dys.Rows.Count > 0)
{
SqlCommand cmf = new SqlCommand("update TBLUserLoginIpRestrictionPreference set MakeIPRestriction='1' where userid='" + ddluser.SelectedValue + "' and compid='" + Session["Comid"] + "' ", con);
con.Open();
cmf.ExecuteNonQuery();
con.Close();
}
else
{
SqlCommand cmf = new SqlCommand("insert into TBLUserLoginIpRestrictionPreference(compid,userid, MakeIPRestriction)values('" + Session["Comid"] + "','" + ddluser.SelectedValue + "','1') ", con);
con.Open();
cmf.ExecuteNonQuery();
con.Close();
}
statuslable.Visible = true;
statuslable.Text = "Record inserted successfully";
txtIpAddress.Text = "";
txtip1.Text = "";
txtip2.Text = "";
txtip3.Text = "";
txtIpAddress.Focus();
FillGridView1();
}
else
{
statuslable.Visible = true;
statuslable.Text = "Record alredy existed";
}
}
else
{
statuslable.Visible = true;
statuslable.Text = "Record not inserted";
}
}
else
{
statuslable.Visible = true;
statuslable.Text = "Please enter IP Address range between 0-255 or *";
}
}
