protected void submit_Click(object sender, EventArgs e) { string sEmail = email.Text; string sAuth_key = authenticate_key.Text; string query = DB_Querys.Authentication(sEmail, sAuth_key); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); SqlDataReader dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { Response.Write("<script>alert('You are not registered for this site contact to Admin');</script>"); } else { while (dbr.Read()) { if (dbr["email"].ToString() == email.Text && dbr["authentication_key"].ToString() == authenticate_key.Text && dbr["is_authenticate"].Equals(true)) { Session[Macros.SESSION_KEY] = dbr["authentication_key"].ToString(); Response.Redirect("site.aspx?skey=" + dbr["sitekey"].ToString()); } else { Response.Write("<script>alert('You are not authenticate for this site');</script>"); } } } }
protected void Page_Load(object sender, EventArgs e) { string query = DB_Querys.GetSideNav(); SqlCommand cmd = null; SqlDataReader dbr = null; dynamic_list.Text = ""; try { if (Session[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].ToString() == null) { Response.Redirect("Default.aspx"); } else { try { DB.CloseConn(); cmd = DB.ExecuteReader(query); dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { } else { while (dbr.Read()) { if (Session[Macros.SESSION_KEY].Equals("Admin") || Session[Macros.SESSION_KEY].Equals("Technician") || Session[Macros.SESSION_KEY].Equals("Account Manager")) { dynamic_list.Text += "<li><a href='" + dbr["redirect"].ToString() + "'>" + dbr["content_name"].ToString() + "</a></li><li class='divider'></li>"; } else { dynamic_list.Text = "<li><a href='#!'>In Progress</a></li>"; } } } } catch (Exception ex) { Response.Redirect("Default.aspx"); } finally { DB.CloseConn(); cmd.Dispose(); dbr.Dispose(); } } } catch (Exception ex) { Response.Redirect("Default.aspx"); } }
protected void submit_Click(object sender, EventArgs e) { string sEmail = email.Text; string sAuth_key = authenticate_key.Text; string query = DB_Querys.Authentication(sEmail, sAuth_key, iSkey); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); SqlDataReader dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { Response.Write("<script>alert('You are not registered for this site contact to Admin');</script>"); } else { while (dbr.Read()) { if (dbr["email"].ToString() == email.Text && dbr["authentication_key"].ToString() == authenticate_key.Text && dbr["is_authenticate"].Equals(true) && dbr["sitekey"].ToString() == iSkey.ToString()) { string sSession = ""; sSession += dbr["permission_level"].ToString() + ","; /* ArrayList sitekeys = getSiteKeys(dbr["email"].ToString()); * string str = ""; * * for (int i=0;i<sitekeys.Count;i++) { * str += sitekeys[i]+","; * }*/ Session[Macros.SESSION_KEY] = sSession + email.Text; // Response.Redirect("sites.aspx"); bAuth = true; break; } else { Response.Write("<script>alert('You are not authenticate for this site');</script>"); } } if (bAuth) { string skey = Cryptography.GetK_Encryption(iSkey.ToString()); Response.Redirect("site.aspx?skey=" + skey); } } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].ToString() == null) { Response.Redirect("Default.aspx"); } else { if (Request.QueryString.Get("skey") == "" || Request.QueryString.Get("skey") == null) { Response.Redirect("Default.aspx"); } else { Queryparam = Cryptography.GetK_Decrypt(Request.QueryString.Get("skey").ToString()); string[] session_arr = Session[Macros.SESSION_KEY].ToString().Split(','); bool bcheck = false; if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { bcheck = DB_Querys.IsSitekeyAvailable(Queryparam); } else { bcheck = DB_Querys.IsSitekeyAvailable(Queryparam, session_arr[session_arr.Length - 1]); } if (bcheck) { // } else { Response.Redirect("Default.aspx"); } } } } catch { Response.Redirect("Default.aspx"); } }
protected void submit_Click(object sender, EventArgs e) { string query = DB_Querys.GetRegisteredUsersQuery(); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); SqlDataReader dbr = cmd.ExecuteReader(); if (!dbr.HasRows) { Response.Write("<script>alert('No Data availabe');</script>"); } else { while (dbr.Read()) { if (dbr["email"].Equals(email.Text) && dbr["password"].Equals(password.Text)) { login_error_msg.Visible = false; Session[Macros.SESSION_KEY] = dbr["category"].ToString(); Response.Redirect("Dashboard.aspx"); } else { // Response.Write("<script>alert('Email :" + dbr["email"].ToString() + " or Password: "******"email"].ToString() + " is incorrent');</script>"); login_error_msg.Visible = true; } } } cmd.Dispose(); dbr.Dispose(); DB.CloseConn(); }
private int AlreadyAvailable() { string query = DB_Querys.CheckAlready(); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); SqlDataReader dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { response = 0; } else { while (dbr.Read()) { if (dbr["email"].ToString() == email.Text && dbr["sitekey"].ToString() == Queryparam) { response = 1; break; } else { response = 0; } } } cmd.Dispose(); dbr.Dispose(); DB.CloseConn(); return(response); }
private ArrayList getSiteKeys(string email) { ArrayList keyList = new ArrayList(); string query = DB_Querys.getSiteKeys(email); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); SqlDataReader dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { keyList.Add("-1"); } else { while (dbr.Read()) { keyList.Add(dbr["sitekey"].ToString()); } } return(keyList); }
private void AddAccessUser() { string query = DB_Querys.AddAccessControl(); DB.CloseConn(); SqlCommand cmd = DB.ExecuteReader(query); access_key = getRandomString(); cmd.Parameters.AddWithValue("@sitekey", Queryparam); cmd.Parameters.AddWithValue("@name", username.Text); cmd.Parameters.AddWithValue("@email", email.Text); cmd.Parameters.AddWithValue("@category", choose.SelectedValue); cmd.Parameters.AddWithValue("@authentication_key", access_key); cmd.Parameters.AddWithValue("@is_authenticate", 1); cmd.Parameters.AddWithValue("@created", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt")); cmd.Parameters.AddWithValue("@updated", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt")); if (choose.SelectedValue.ToLower().Equals(Macros.sADMIN)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iADMIN); } else if (choose.SelectedValue.ToLower().Equals(Macros.sACCOUNT_MANAGER)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iACCOUNT_MANAGER); } else if (choose.SelectedValue.ToLower().Equals(Macros.sTECHNICIAN)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iTECHNICIAN); } else if (choose.SelectedValue.ToLower().Equals(Macros.sMANAGER)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iMANAGER); } else if (choose.SelectedValue.ToLower().Equals(Macros.sEMPLOYEE)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iEMPLOYEE); } else if (choose.SelectedValue.ToLower().Equals(Macros.sCLIENT)) { cmd.Parameters.AddWithValue("@permission_level", Macros.iCLIENT); } else { cmd.Parameters.AddWithValue("@permission_level", Macros.iNOTACCESS); } int res = cmd.ExecuteNonQuery(); cmd.Dispose(); DB.CloseConn(); if (res == 1) { //send mail for access users SendMail(Macros.ACCESS_URL, access_key); Response.Write("<script>alert('Signup Successfull and check your mail!');</script>"); } else { Response.Write("<script>alert('Somthing Error!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { int permission_level = 105; string postype = Request.QueryString.Get("postype"); string query = DB_Querys.GetSites(postype); SqlCommand cmd = null; SqlDataReader dbr = null; GTICLOUD.navbar.dropstring = ""; sitebox.Text = ""; try { if ((Session[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].ToString() == null)) { Response.Redirect("Default.aspx"); } else { if (permission_level == Macros.iSUPER_ADMIN) { GTICLOUD.navbar.dropstring += " <li><a href='createsite.aspx'>Create Site</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Settings</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Logout</a></li>"; } else { GTICLOUD.navbar.dropstring += " <li><a href='#!'>Settings</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Logout</a></li>"; } try { DB.CloseConn(); cmd = DB.ExecuteReader(query); dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { sitebox.Text += "<div><h4 class='center-align red-text'>No Data Available</h4></div>"; } else { while (dbr.Read()) { sitebox.Text += "<div class='col s12 m4'>"; sitebox.Text += "<div class='card white'>"; sitebox.Text += "<div class='card-content black-text'>"; if (permission_level == Macros.iSUPER_ADMIN) { sitebox.Text += "<span class='card-title activator grey-text text-darken-4'>" + dbr["sitename"].ToString() + "<i class='material-icons right'>more_vert</i></span>"; } else { sitebox.Text += "<span class='card-title black-text'>" + dbr["sitename"].ToString() + "</span>"; } sitebox.Text += "<p> POS ID : " + dbr["siteid"].ToString() + "</p>"; sitebox.Text += "<p> POS Type : " + dbr["postype"].ToString().ToUpper() + "</p>"; sitebox.Text += "<p> <span>Updated :</span><span>" + dbr["regitered"].ToString() + "</span> </p>"; sitebox.Text += " <p> <span>Created : </span><span>" + dbr["updated"].ToString() + "</span> </p>"; sitebox.Text += "</div>"; if (permission_level == Macros.iSUPER_ADMIN) { sitebox.Text += @"<div class='card-reveal'> <span class='card-title grey-text text-darken-4'>Access Control<i class='material-icons right'>close</i></span><br/> <a class='waves-effect waves-light btn' href='AccessControl.aspx?skey=" + dbr["sitekey"].ToString() + "'>authorization</a>"; sitebox.Text += "</div> "; } sitebox.Text += "<div class='card-action'>"; sitebox.Text += "<a href='site.aspx?siteid=" + dbr["siteid"].ToString() + "&sitekey=" + dbr["sitekey"].ToString() + "' class='theme-color'>GO TO SITE</a>"; sitebox.Text += @"</div> </div> </div>"; } } } catch (Exception ex) { Response.Redirect("Default.aspx"); } finally { DB.CloseConn(); cmd.Dispose(); dbr.Dispose(); } } } catch (Exception ex) { Response.Redirect("Default.aspx"); } }
/* protected void btn_Click(object sender, EventArgs e) * { * // Button btn = (Button)sender; * HtmlInputButton btn = (HtmlInputButton)sender; * string str = btn.ID; * }*/ protected void Page_Load(object sender, EventArgs e) { //btn1.ServerClick += new EventHandler(btn_Click); try { GTICLOUD.navbar.dropstring = ""; string skey = Cryptography.GetK_Decrypt(Request.QueryString.Get("skey").ToString()); string[] session_arr = Session[Macros.SESSION_KEY].ToString().Split(','); sFileInfo = DB_Querys.GetFileConfigId(Convert.ToInt32(skey)); try { if (Session[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].ToString() == null) { if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { Response.Redirect("Default.aspx"); } else { Response.Redirect("authenticate.aspx"); } } else { //get all data accornding Session[Macros.SESSION_SITE_KEY].ToString() // Response.Write("<h3>"+heddinfld.Value+"</h3>"); string st = skey; //string[] session_arr = Session[Macros.SESSION_KEY].ToString().Split(','); sitekey = Convert.ToInt32(st); bool bcheck = false; if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { bcheck = DB_Querys.IsSitekeyAvailable(st); } else { bcheck = DB_Querys.IsSitekeyAvailable(st, session_arr[session_arr.Length - 1]); } if (bcheck) { // } else { if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { Response.Redirect("Default.aspx"); } else { Response.Redirect("authenticate.aspx"); } } //int view = (Convert.ToInt32(st.ToCharArray()[0]) - 33); // Response.Write("<h3>" + st + "</h3>"); GTICLOUD.navbar.dropstring += " <li><a href='#!'>Settings</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Logout</a></li>"; } string permission_level = session_arr[0]; string mailId = session_arr[1]; int FileId = 0; if (sFileInfo == "") { FileId = 0; ConfigLinkBtn.Visible = false; } else { FileId = Convert.ToInt32(sFileInfo.Split(',')[0]); } ArrayList VerifyArr = DB_Querys.IsVerifiedByAdmin(sitekey, permission_level, mailId, FileId); if (VerifyArr[0].Equals(true) && VerifyArr[1].Equals(false)) { ProcessLabel.Visible = false; NowDownload.Visible = true; download_msg.Visible = false; ConfigLinkBtn.Visible = false; refresh.Visible = false; } if (VerifyArr[0].Equals(false) && VerifyArr[1].Equals(true)) { ProcessLabel.Visible = true; NowDownload.Visible = false; ConfigLinkBtn.Visible = false; download_msg.Visible = true; refresh.Visible = true; } } catch (Exception ex) { if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { Response.Redirect("Default.aspx"); } else { Response.Redirect("authenticate.aspx"); } } } catch { Response.Redirect("Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { sSession = Session[Macros.SESSION_KEY].ToString().Split(','); if ((Session[Macros.SESSION_KEY].ToString() != null && Session[Macros.SESSION_KEY].ToString() != "") && (sSession[0] == Macros.iSUPER_ADMIN.ToString())) { string skey = Request.QueryString.Get("skey"); int iSkey = 0; if (skey != "" && skey != null) { iSkey = Convert.ToInt32(Cryptography.GetK_Decrypt(skey)); string query = "select * from accessControl where sitekey='" + iSkey + "'"; SqlDataReader dbr = DB_Querys.GetAuntherizedUserData(query); if (dbr.HasRows == false) { // } else { autherizedLabel.Text += @"<table> <thead> <tr> <th>ID</th> <th>Site Key</th> <th>Email</th> <th>Category</th> <th>Authentication Key</th> <th>Authenticated</th> <th>Name</th> <th>Created</th> <th>Updated</th> <th>Permission Level</th> </tr> </thead> <tbody> "; while (dbr.Read()) { autherizedLabel.Text += "<tr>"; for (int i = 0; i < dbr.FieldCount; i++) { autherizedLabel.Text += "<td>" + dbr[i].ToString() + "</td>"; } autherizedLabel.Text += "<td><a class='waves-effect waves-light btn authbtn' uid='" + dbr[0].ToString() + "' skey='" + dbr[1].ToString() + "' >DeActive</a>"; autherizedLabel.Text += "</tr>"; } autherizedLabel.Text += @" </tbody> </table>"; } } } else { Response.Redirect("Error.aspx"); } } catch { Response.Redirect("Error.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { int permission_level = 0; string sSiteKeys = ""; //string Sessionemail = ""; try { string[] session_arr = Session[Macros.SESSION_KEY].ToString().Split(','); if (Convert.ToInt32(session_arr[0]) == Macros.iSUPER_ADMIN) { permission_level = Convert.ToInt32(session_arr[0]); } else { permission_level = Convert.ToInt32(session_arr[0]); // Session[Macros.SESSION_KEY] = session_arr[session_arr.Length - 1]; for (int j = 1; j < session_arr.Length - 1; j++) { sSiteKeys += session_arr[j] + ","; } } } catch (Exception ex) { if (permission_level != Macros.iSUPER_ADMIN) { Response.Redirect("authenticate.aspx"); } else { Response.Redirect("Default.aspx"); } } //int permission_level = Convert.ToInt32(Session[Macros.SESSION_KEY].ToString());/*Convert.ToInt32(Request.QueryString.Get("plevel"));*/ //string postype = Request.QueryString.Get("postype"); //string sitekey=Request.QueryString.Get("skey"); string query = ""; if (permission_level == Macros.iSUPER_ADMIN) { query = DB_Querys.GetSites(); } else { query = DB_Querys.GetSitesAccordingKeys(sSiteKeys.Substring(0, sSiteKeys.Length - 1)); } SqlCommand cmd = null; SqlDataReader dbr = null; GTICLOUD.navbar.dropstring = ""; sitebox.Text = ""; try { if ((Session[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].ToString() == null)) { Response.Redirect("Default.aspx"); } else { if (permission_level == Macros.iSUPER_ADMIN) { GTICLOUD.navbar.dropstring += " <li><a href='createsite.aspx'>Create Site</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Settings</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Logout</a></li>"; } else { GTICLOUD.navbar.dropstring += " <li><a href='#!'>Settings</a></li>"; GTICLOUD.navbar.dropstring += " <li><a href='#!'>Logout</a></li>"; } try { DB.CloseConn(); cmd = DB.ExecuteReader(query); dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { sitebox.Text += "<div><h4 class='center-align red-text'>No Data Available</h4></div>"; } else { while (dbr.Read()) { sitebox.Text += "<div class='col s12 m4'>"; sitebox.Text += "<div class='card white'>"; sitebox.Text += "<div class='card-content black-text'>"; if (permission_level == Macros.iSUPER_ADMIN) { sitebox.Text += "<span class='card-title activator grey-text text-darken-4'>" + dbr["sitename"].ToString() + "<i class='material-icons right'>more_vert</i></span>"; } else { sitebox.Text += "<span class='card-title black-text'>" + dbr["sitename"].ToString() + "</span>"; } sitebox.Text += "<p> POS ID : " + dbr["siteid"].ToString() + "</p>"; sitebox.Text += "<p> POS Type : " + dbr["postype"].ToString().ToUpper() + "</p>"; sitebox.Text += "<p> <span>Updated :</span><span>" + dbr["regitered"].ToString() + "</span> </p>"; sitebox.Text += " <p> <span>Created : </span><span>" + dbr["updated"].ToString() + "</span> </p>"; sitebox.Text += "</div>"; if (permission_level == Macros.iSUPER_ADMIN) { sitebox.Text += @"<div class='card-reveal'> <span class='card-title grey-text text-darken-4'>Access Control<i class='material-icons right'>close</i></span><br/> <a class='waves-effect waves-light btn' href='AccessControl.aspx?skey=" + Cryptography.GetK_Encryption(dbr["sitekey"].ToString()) + "' >authorization</a> <a class='waves-effect waves-light btn' href='Unauth.aspx?skey=" + Cryptography.GetK_Encryption(dbr["sitekey"].ToString()) + "' >Unauthorization</a>"; sitebox.Text += "</div>"; } //Session["SiteID"] = dbr["siteid"].ToString(); sitebox.Text += "<div class='card-action'>"; sitebox.Text += "<a href='site.aspx?skey=" + Cryptography.GetK_Encryption(dbr["sitekey"].ToString()) + "' class='theme-color')'>GO TO SITE</a>"; sitebox.Text += @"</div> </div> </div>"; // Session["sitekey"] = dbr["sitekey"].ToString(); } } } catch (Exception ex) { if (permission_level != Macros.iSUPER_ADMIN) { Response.Redirect("authenticate.aspx"); } else { Response.Redirect("Default.aspx"); } } finally { DB.CloseConn(); cmd.Dispose(); dbr.Dispose(); } } } catch (Exception ex) { if (permission_level != Macros.iSUPER_ADMIN) { Response.Redirect("authenticate.aspx"); } else { Response.Redirect("Default.aspx"); } } }