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