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>");
}
}
}
}
internal static string GetFileConfigId(int sitekey)
{
string fileInfo = "";
string query = "select file_id,file_name,source_path from config_files where sitekey=" + sitekey;
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
SqlDataReader dbr = cmd.ExecuteReader();
if (dbr.HasRows == false)
{
fileInfo = "";
}
else
{
while (dbr.Read())
{
fileInfo = dbr[0].ToString() + "," + dbr[1].ToString() + "," + dbr[2].ToString();
}
}
DB.CloseConn();
return(fileInfo);
}
internal static ArrayList IsVerifiedByAdmin(int sitekey, string permission_level, string mailId, int FileId)
{
ArrayList BoolArr = new ArrayList();
string query = "select accept,inprocess from DownloadFileReq where sitekey='" + sitekey + "' and permission_level='" + permission_level + "' and sender_email='" + mailId + "' and file_id='" + FileId + "'";
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
SqlDataReader dbr = cmd.ExecuteReader();
if (dbr.HasRows == false)
{
BoolArr.Add(false);
BoolArr.Add(false);
}
else
{
while (dbr.Read())
{
if (dbr[0].Equals(true) && dbr[1].Equals(false))
{
BoolArr.Add(true);
BoolArr.Add(false);
}
if (dbr[0].Equals(false) && dbr[1].Equals(true))
{
BoolArr.Add(false);
BoolArr.Add(true);
}
}
}
DB.CloseConn();
return(BoolArr);
}
protected void submit_Click(object sender, EventArgs e)
{
string query = "select email,password from registration;";
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))
{
Response.Redirect("Dashboard.aspx");
}
else
{
Response.Write("<script>alert('Email or Password is incorrent');</script>");
break;
}
}
}
cmd.Dispose();
dbr.Dispose();
DB.CloseConn();
}
private void AccesptRequest(int iauth, int iSiteKey, int iFileId, string sMailId, int iOutProcess)
{
DB.CloseConn();
string query = "update DownloadFileReq set accept='" + iauth + "' , inprocess='" + iOutProcess + "' where sitekey='" + iSiteKey + "' and sender_email='" + sMailId + "' and file_id='" + iFileId + "'";
DB.ExecuteNonQuery(query);
DB.CloseConn();
}
internal static SqlDataReader GetAuntherizedUserData(string query)
{
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
SqlDataReader dbr = cmd.ExecuteReader();
return(dbr);
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString.Get("id"));
skey = Convert.ToInt32(Request.QueryString.Get("sitekey"));
string query = "update accessControl set is_authenticate=0 where id='" + id + "' and sitekey='" + skey + "'";
DB.CloseConn();
DB.ExecuteNonQuery(query);
DB.CloseConn();
}
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);
}
}
}
private void AuthenticateUserByAdmin(string sender_email)
{
int fileID = 0;
string sFileName = "";
string sFilePath = "";
if (sFileInfo != "")
{
fileID = Convert.ToInt32(sFileInfo.Split(',')[0]);
sFileName = sFileInfo.Split(',')[1];
sFilePath = sFileInfo.Split(',')[2];
}
bool req = SendRequestMail(sender_email, sitekey, fileID);
if (req == true)
{
int siteKey = sitekey;
string senderemail = sender_email;
string requestDateTime = DateTime.Now.ToString("yyyy/MM/dd");
string permission_level = Session[Macros.SESSION_KEY].ToString().Split(',')[0];
string accepter_email = sender_email;
string query = "insert into DownloadFileReq (sitekey,sender_email,requestdatetime,permission_level,accepter_email,accept,file_id,file_name,filepath,inprocess) values (@sitekey,@sender_email,@requestdatetime,@permission_level,@accepter_email,@accept,@file_id,@file_name,@filepath,@inprocess)";
DB.CloseConn();
DB.OpenConn();
SqlCommand cmd = new SqlCommand(query, DB.OpenConn());
cmd.Parameters.AddWithValue("@sitekey", sitekey);
cmd.Parameters.AddWithValue("@sender_email", senderemail);
cmd.Parameters.AddWithValue("@requestdatetime", requestDateTime);
cmd.Parameters.AddWithValue("@permission_level", permission_level);
cmd.Parameters.AddWithValue("@accepter_email", accepter_email);
cmd.Parameters.AddWithValue("@accept", 0);
cmd.Parameters.AddWithValue("@file_id", fileID);
cmd.Parameters.AddWithValue("@file_name", sFileName);
cmd.Parameters.AddWithValue("@filepath", sFilePath);
cmd.Parameters.AddWithValue("@inprocess", 1);
DB.ExecuteNoneQuery(cmd);
download_msg.Visible = true;
ConfigLinkBtn.Visible = false;
ProcessLabel.Visible = true;
ProcessLabel.ForeColor = System.Drawing.Color.Green;
}
else
{
Response.Write("<script>alert('Access Mail not sent please try again or contact to Admin');</script>");
}
}
protected void submit_Click(object sender, EventArgs e)
{
if (backofficeuser.Text.Equals(Macros.BACKOFFICE_VALUE) && backofficepassword.Text.Equals(Macros.BACKOFFICE_KEY))
{
int siteid = new Random().Next(100, 100000);
/* try
* {*/
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
cmd.Parameters.AddWithValue("@sitename", sitename.Text);
cmd.Parameters.AddWithValue("@siteid", siteid);
cmd.Parameters.AddWithValue("@postype", postype.Text);
cmd.Parameters.AddWithValue("@backofficeuserid", backofficeuser.Text);
cmd.Parameters.AddWithValue("@backofficepassword", backofficepassword.Text);
cmd.Parameters.AddWithValue("@regitered", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt"));
cmd.Parameters.AddWithValue("@updated", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt"));
int res = cmd.ExecuteNonQuery();
cmd.Dispose();
DB.CloseConn();
if (res == 1)
{
Response.Write("<script>alert('Site Create Successfuly!');</script>");
Response.Redirect("sites.aspx");
}
else
{
Response.Write("<script>alert('Somthing Error!');</script>");
}
/*}
* catch (Exception ex)
* {
*
* Response.Write("<script>alert('Error!');</script>");
* }*/
}
else
{
Response.Write("<script>alert('Inccrorect Username or Password');</script>");
}
}
protected void submit_Click(object sender, EventArgs e)
{
if (choose.SelectedIndex == 0)
{
Response.Write("<script>alert('Please select your catagory');</script>");
}
else
{
/* try
* {*/
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
cmd.Parameters.AddWithValue("@username", username.Text);
cmd.Parameters.AddWithValue("@email", email.Text);
cmd.Parameters.AddWithValue("@category", choose.SelectedValue);
cmd.Parameters.AddWithValue("@password", create_pass.Text);
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"));
int res = cmd.ExecuteNonQuery();
cmd.Dispose();
DB.CloseConn();
if (res == 1)
{
Response.Write("<script>alert('Signup Successfull!');</script>");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("<script>alert('Somthing Error!');</script>");
}
/*}
* catch (Exception ex)
* {
*
* Response.Write("<script>alert('Error!');</script>");
* }*/
}
}
internal static bool IsSitekeyAvailable(string sitekey)
{
string query = "select sitekey from sites where sitekey='" + sitekey + "'";
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
SqlDataReader dbr = cmd.ExecuteReader();
if (dbr.HasRows == false)
{
return(false);
}
else
{
return(true);
}
DB.CloseConn();
cmd.Dispose();
dbr.Dispose();
}
internal static bool IsSitekeyAvailable(string sitekey, string email)
{
string query = "select S.sitekey,A.email from sites S inner join accessControl A on S.sitekey=A.sitekey where A.email='" + email + "' and A.sitekey='" + sitekey + "'";
DB.CloseConn();
SqlCommand cmd = DB.ExecuteReader(query);
SqlDataReader dbr = cmd.ExecuteReader();
if (dbr.HasRows == false)
{
return(false);
}
else
{
return(true);
}
DB.CloseConn();
cmd.Dispose();
dbr.Dispose();
}
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["permission_level"].ToString() + "," + email.Text;
Response.Redirect("sites.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();
}
protected void submit_Click(object sender, EventArgs e)
{
string query = "select email,password,category from registration;";
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) && dbr["category"].Equals(choose.SelectedItem.ToString()))
{
login_error_msg.Visible = false;
Session["global"] = 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);
}
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");
}
}
}
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[Macros.SESSION_KEY].ToString() == "" || Session[Macros.SESSION_KEY].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().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>";
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();
}
}
}
catch (Exception ex)
{
Response.Redirect("Default.aspx");
}
}
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>");
}
}
