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");
}
}
}
