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) { string query = "select sitename,siteid,postype,regitered,updated from sites"; SqlCommand cmd = null; SqlDataReader dbr = null; GTICLOUD.navbar.dropstring = ""; sitebox.Text = ""; try { if (Session["global"].ToString() == "" || Session["global"].ToString() == null) { Response.Redirect("Default.aspx"); } else { 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>"; try { DB.CloseConn(); cmd = DB.ExecuteReader(query); dbr = cmd.ExecuteReader(); if (dbr.HasRows == false) { } else { while (dbr.Read()) { if (dbr["postype"].ToString().ToLower().Equals("food")) { sitebox.Text += "<div class='col s12 m4'>"; sitebox.Text += "<div class='card white'>"; sitebox.Text += "<div class='card-content black-text'>"; sitebox.Text += "<span class='card-title'>" + dbr["sitename"].ToString() + "</span>"; sitebox.Text += "<p> POS ID : " + dbr["siteid"].ToString() + "</p>"; sitebox.Text += "<p> POS Type : " + dbr["postype"].ToString() + "</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>"; sitebox.Text += "<div class='card-action'>"; sitebox.Text += "<a href='site.aspx' 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(); } /* * * <div class="col s12 m4"> * <div class="card white"> * <div class="card-content black-text"> * <span class="card-title">Site One</span> * <p> * Los Anglies South Zone(USA) * </p> * <p> * <span>Updated :</span><span>2018-09-30 11:35 PM</span> * </p> * <p> * <span>Created : </span><span>2018-09-30 11:35 PM</span> * </p> * </div> * <div class="card-action"> * <a href="site.aspx" class="theme-color">GO TO SITE</a> * </div> * </div> * </div> * */ } } catch (Exception ex) { Response.Redirect("Default.aspx"); } }
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 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"); } } }