private static void LoadMenuLeft(ActionExecutingContext filterContext)
{
string ActionName = filterContext.RouteData.Values["action"].ToString();
string ControllerName = filterContext.RouteData.Values["controller"].ToString();
string AreaName = filterContext.RouteData.DataTokens["area"] != null ? filterContext.RouteData.DataTokens["area"].ToString() : "";
int?GroupId = int.Parse(Auth.GetCookie("DGroupId")) as int?;
DBAdmin db = new DBAdmin();
tbMenu root = db.tbMenus.Where(p => p.MenuName == "Root").FirstOrDefault();
List <tbMenuInGroup> ListMenu = new List <tbMenuInGroup>();
if (root != null)
{
List <tbMenu> ListT = db.tbMenus.Where(p => p.IdRoot == root.tbMenuId && p.IsDisable == false && p.IsMenu == true).OrderBy(x => x.Order).ToList();
if (ListT != null)
{
ListT.ForEach(x => ListMenu.Add(new tbMenuInGroup(x, GroupId.Value)));
}
}
filterContext.Controller.ViewBag.ListMenu = ListMenu;
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Panel1.Visible = true;
int eid;
string q;
Button btnRespond = (Button)(sender);
GridViewRow gRow = (GridViewRow)(btnRespond.Parent.Parent);
eid = int.Parse(gRow.Cells[1].Text);
Enquiryid.Text = "Enquiry ID: " + eid.ToString();
q = "select * from tbl_Enquiry where Enquiry_id='" + eid + "';";
DBAdmin db = new DBAdmin();
DataTable dt = new DataTable();
dt = db.ReadBulkData(q);
emailid = dt.Rows[0][2].ToString();
//Session["kid"] = emailid;
Label2.Text = emailid;
}
catch (Exception ex)
{
}
}
public static void ReloadInfoUser()
{
string DUser = Auth.GetCookie("DUser");
if (DUser == DDefault.SAdminID)
{
HttpContext.Current.Session["DUserName"] = "******";
HttpContext.Current.Session["DUserAvatar"] = "defaultavatar.png";
Auth.SetCookie("DGroupId", 0);
}
else
{
DBAdmin db = new DBAdmin();
tbUser tbUser = db.tbUsers.Where(p => p.Username == DUser).FirstOrDefault();
if (tbUser == null)
{
return;
}
HttpContext.Current.Session["DUserName"] = tbUser.Fullname;
HttpContext.Current.Session["DUserAvatar"] = string.IsNullOrEmpty(tbUser.AvatarUrl) ? "defaultavatar.png" : tbUser.AvatarUrl;
// tbGroupId
tbGroupUser tbMemberGroup = db.tbGroupUsers.Where(x => x.tbUserId == tbUser.tbUserId).FirstOrDefault();
if (tbMemberGroup == null)
{
Auth.SetCookie("DGroupId", -1);
}
else
{
Auth.SetCookie("DGroupId", tbMemberGroup.tbGroupId);
}
}
}
private void NewStateNameButtonClick(object sender, ButtonPressedEventArgs e)
{
var layout = DBAdmin.UserLayout_Insert(controlForm.Name, editor.Name, ((ButtonEdit)sender).MaskBox.MaskBoxText, editor.GetLayoutData(), 0);
layouts.Add(layout);
MessageWindow.GetInstance("Настройка состояния успешно сохранена", MessageType.Info);
menu.HidePopup();
}
protected void Button1_Click(object sender, EventArgs e)
{
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Registration");
gviewallrecords.DataSource = dt;
gviewallrecords.DataBind();
}
protected void ddlcategory_SelectedIndexChanged(object sender, EventArgs e)
{
string category = ddlcategory.SelectedItem.Text;
if (category == "Web Technology")
{
MView.SetActiveView(viewWT);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewWT.DataSource = dt;
GviewWT.DataBind();
}
if (category == "Programming")
{
MView.SetActiveView(viewPro);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewPro.DataSource = dt;
GviewPro.DataBind();
}
if (category == "Database")
{
MView.SetActiveView(viewDB);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewDB.DataSource = dt;
GviewDB.DataBind();
}
if (category == "Operating System")
{
MView.SetActiveView(viewOS);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewOS.DataSource = dt;
GviewOS.DataBind();
}
if (category == "Computer Organisation And Architecture")
{
MView.SetActiveView(viewCOA);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewCOA.DataSource = dt;
GviewCOA.DataBind();
}
if (category == "Fundamental of Computers")
{
MView.SetActiveView(viewFOC);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewFOC.DataSource = dt;
GviewFOC.DataBind();
}
}
private void DeleleRecursion_tbMenu(DBAdmin db, tbMenu rd)
{
List <tbMenu> arrmenu = db.tbMenus.Where(x => x.IdRoot == rd.tbMenuId).ToList();
if (arrmenu.Count() > 0)
{
foreach (var c in arrmenu)
{
this.DeleleRecursion_tbMenu(db, c);
}
}
db.tbMenus.Remove(rd);
db.SaveChanges();
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
string Error = "";
DBAdmin adminObj = new DBAdmin();
if (adminObj.getAdminLogin(TextBoxAdminName.Text, TextBoxPassword.Text, ref Error))
{
Session["AdminLogin"] = TextBoxAdminName.Text;
Response.Redirect("~/Admin/AdminHome.aspx");
}
else
{
Response.Redirect("~/Admin/AdminLogin.aspx");
}
}
private static void CreateDatabaseTables()
{
string filename = DBAdmin.CreateDBFile();
if (EventLogTableMgr.CreateEventLogDBTable())
{
Logger.AddLogEntry(LogCategory.INFO, "Created Database file \'" + filename + "\'.");
}
SettingsTableMgr.CreateSettingsDBTable();
AudioClipsTableMgr.CreateAudioClipsDBTable();
TimeTriggerClipsTableMgr.CreateTimeTriggerClipsDBTable();
RulesetsTableMgr.CreateRulesetsDBTable();
RulesTableMgr.CreateRulesetRulesDBTable();
SessionsTableMgr.CreateSessionsDBTable();
SessionClipsTableMgr.CreateSessionsDBTable();
OnlineVoicesTableMgr.CreateOnlineVoicesDBTable();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == true)
{
string fname, q;
fname = FileUpload1.FileName;
string category = DropDownList1.SelectedItem.Text;
if (category == "Web Technology")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Web Technology/" + fname));
}
else if (category == "Computer Organisation And Architecture")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Computer Organisation And Architecture/" + fname));
}
else if (category == "Programming")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Programming/" + fname));
}
else if (category == "Database")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Database/" + fname));
}
else if (category == "Fundamental of Computers")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Fundamental of Computers/" + fname));
}
else if (category == "Operating System")
{
FileUpload1.SaveAs(MapPath("~/MATERIAL/Operating System/" + fname));
}
q = "insert into tbl_UploadMaterial values('" + txtSubjectName.Text + "','" + fname + "','" + category + "','" + DateTime.Now + "')";
DBAdmin dm = new DBAdmin();
bool j = dm.IUD(q);
if (j == true)
{
GridView1.DataSource = db.ReadBulkData("select * from tbl_UploadMaterial");
GridView1.DataBind();
//jaise hi upload ho waise hi show ho jaye...
Response.Write("<script>alert('Study Material uploaded successfully')</script>");
}
}
txtSubjectName.Text = "";
}
protected void Button1_Click(object sender, EventArgs e)
{
string q;
q = "insert into tbl_enquiry values('" + txtName.Text + "','" + txtemail.Text + "','" + txtcontact.Text + "','" + txtMessage.Text + "','" + DateTime.Now + "')";
DBAdmin dm = new DBAdmin();
bool j = dm.IUD(q);
if (j == true)
{
Response.Write("<script>alert('Enquiry Submitted')</script>");
}
else
{
Response.Write("<script>alert('Enquiry Not Submitted')</script>");
}
}
/// <summary>
/// Hàm kiểm tra dành cho đăng nhập
/// <para>Được sử riêng cho trang Login</para>
/// </summary>
/// <param name="username">Tài khoản</param>
/// <param name="password">Mật khẩu</param>
/// <param name="remember">Ghi nhớ tài khoản bằng Cookie</param>
/// <returns>bool</returns>
public static bool CheckLogin(string username, string password, bool remember = false)
{
if (username == DDefault.SAdminID && password == DDefault.SAdminPW)
{
//Setup quyền cho Supper Admin
SetCookie("DUser", DDefault.SAdminID);
ReloadInfoUser();
if (remember)
{
SetCookie(DDefault.NameCookieRemember, username, 24 * DDefault.DayCookiesLogin);
}
else
{
ClearCookie(DDefault.NameCookieRemember);
}
return(true);
}
//Check tài khoàn đăng nhập = database thông thường
else
{
DBAdmin db = new DBAdmin();
password = DHash.Encrypt(password);
tbUser tbUser = db.tbUsers.Where(p => p.Username == username && p.Password == password).FirstOrDefault();
if (tbUser == null)
{
return(false);
}
SetCookie("DUser", tbUser.Username);
ReloadInfoUser();
if (remember)
{
SetCookie(DDefault.NameCookieRemember, username);
}
else
{
ClearCookie(DDefault.NameCookieRemember);
}
return(true);
}
}
public static bool InitialiseApp() // called from MainWindow
{
DirectoryMgr.SetAppDirectories();
if (DBAdmin.DefaultDatabaseExists())
{
LoadDatabaseTables();
}
else
{
CreateDatabaseTables();
LoadDatabaseTables();
}
// Check audio files exist for loaded audioclips
if (Settings.CheckAudioFiles)
{
Task.Factory.StartNew(() => AudioFileAuditor.CheckAudioFiles());
}
return(true);
}
protected void Submit_btn_Click(object sender, EventArgs e)
{
DBAdmin db = new DBAdmin();
if (Captcha_lbl.Text.Trim() == captcha_text.Text.Trim())
{
if (db.callingStoredProcedure(Name_txt.Text, Gender_list.SelectedValue, clg_name_txt.Text, course_dropdown.SelectedValue, year_list.SelectedValue, contact_txt.Text, picUploader.FileName, pass_text.Text, mail_txt.Text) == true)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Try again')", true);
}
}
else
{
Captcha_error.Text = "Please Enter Correct Captcha Code";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Panel1.Visible = false;
string q;
q = "select * from tbl_enquiry ";
DBAdmin dm = new DBAdmin();
DataTable dt = new DataTable();
dt = dm.ReadBulkData(q);
if (dt.Rows.Count > 0)
{
GridView2.DataSource = dt;
GridView2.DataBind();
}
else
{
Response.Write("<script>alert('Record Not Found')</script>");
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string username, password, c, q;
username = txtUsername.Text;
password = txtPassword.Text;
c = DropDownList1.Text;
q = "select * from TBL_login where user_id='" + username + "'and pass='******'and user_type='" + c + "'";
DBAdmin dm = new DBAdmin();
DataTable dt = new DataTable();
dt = dm.ReadBulkData(q);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][2].ToString().Trim().Equals("User"))
{
if (dt.Rows[0][3].ToString().Trim().Equals("Active"))
{
Session["uid"] = username;
Response.Redirect("~/USERSEGMENT/UserHome.aspx");
}
else
{
Response.Write("<script>alert('Account disable Contact to Administrator ')</script>");
}
}
else
{
Session["uid"] = username;
Response.Redirect("~/ADMINSEGMENT/Home.aspx");
}
}
else
{
Response.Write("<script>alert('Invalid Userid and Password')</script>");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
Button btnRespond = (Button)(sender);
GridViewRow gRow = (GridViewRow)(btnRespond.Parent.Parent);
Enquiryid.Text = gRow.Cells[1].Text;
string q;
q = "delete from tbl_enquiry where Enquiry_id='" + Enquiryid.Text + "'";
DBAdmin dm = new DBAdmin();
dm.IUD(q);
DataTable dt = new DataTable();
dt = dm.ReadBulkData("select * from tbl_enquiry");
if (dt.Rows.Count > 0)
{
GridView2.DataSource = dt;
GridView2.DataBind();
}
}
catch (Exception ex)
{
}
}
// Start is called before the first frame update
void Start()
{
_db = FindObjectOfType <DBAdmin>();
}
/// <summary>
/// Hàm check quyền của control Admin
/// </summary>
/// <param name="ct">Control hiện tại (this)</param>
/// <returns>int</returns>
public static int IsUse(Controller ct, string area = "")
{
string ActionName = ct.ControllerContext.RouteData.Values["action"].ToString().ToLower();
string ControllerName = ct.ControllerContext.RouteData.Values["controller"].ToString().ToLower();
string AreaName = ct.ControllerContext.RouteData.DataTokens["area"] != null ? ct.ControllerContext.RouteData.DataTokens["area"].ToString().ToLower() : "";
string MethodName = ct.ControllerContext.HttpContext.Request.HttpMethod;
//string Ip = IPAddress;
HttpCookie getCookie = HttpContext.Current.Request.Cookies[DDefault.NameCookieRemember];
if (getCookie != null)
{
if (GetCookie("DUser") == null)
{
SetCookie("DUser", DHash.Decrypt(getCookie.Value));
if (HttpContext.Current.Session["DUserName"] == null)
{
ReloadInfoUser();
}
}
}
string DUser = GetCookie("DUser");
/// Kiểm tra các lỗi xảy ra
/// Nếu không đúng phân vùng Area: Thông báo lỗi 404
if (area != "" && AreaName != area.ToLower())
{
HttpContext.Current.Session["ErrorHttp"] = ct.Request.RawUrl;
_Auth = -1;
return(-1);
}
/// Nếu chưa đăng nhập
/// Chuyển về trang đăng nhập
if (DUser == null)
{
HttpContext.Current.Session["returnUrl"] = ct.Request.RawUrl;
_Auth = -2;
return(-2);
}
/// Đặc quyền cho SUPERADMIN
if (DUser == DDefault.SAdminID)
{
HttpContext.Current.Session["ErrorHttp"] = "";
HttpContext.Current.Session["returnUrl"] = "";
_Auth = 1;
LoadBreadcrumb(ct);
LoadMenuLeft(ct);
return(1);
}
DBAdmin db = new DBAdmin();
int? GroupId = int.Parse(GetCookie("DGroupId")) as int?;
tbMenuInGroup tbMenuInGroup = new tbMenuInGroup(db.tbMenus.Where(p => p.IsDisable == false && p.Controller.ToLower() == ControllerName && p.Action.ToLower() == ActionName).FirstOrDefault(), GroupId.Value);
if (tbMenuInGroup.IsIn)
{
/// Trường hợp thỏa các điều kiện
HttpContext.Current.Session["ErrorHttp"] = "";
HttpContext.Current.Session["returnUrl"] = "";
_Auth = 1;
LoadBreadcrumb(ct);
LoadMenuLeft(ct);
return(1);
}
else
{
/// Nếu tài khoản không đủ quyền
/// Chuyển về trang thông báo quyền truy cập hoặc 404
HttpContext.Current.Session["ErrorHttp"] = ct.Request.RawUrl;
_Auth = 0;
return(0);
}
}
public override void OnActionExecuting(ActionExecutingContext filter)
{
string ActionName = filter.RouteData.Values["action"].ToString().ToLower();
string ControllerName = filter.RouteData.Values["controller"].ToString().ToLower();
string AreaName = filter.RouteData.DataTokens["area"] != null ? filter.RouteData.DataTokens["area"].ToString().ToLower() : "";
string MethodName = filter.HttpContext.Request.HttpMethod;
// GET AREAS
string Areas = "";
string[] arrT = filter.Controller.GetType().ToString().Split('.');
if (arrT.Length >= 3) //DreamCMS.Areas.Admin.Controllers. ...
{
if (arrT[1] == "Areas")
{
Areas = arrT[2];
}
}
HttpCookie getCookie = HttpContext.Current.Request.Cookies[DDefault.NameCookieRemember];
if (getCookie != null)
{
if (Auth.GetCookie("DUser") == null)
{
Auth.SetCookie("DUser", DHash.Decrypt(getCookie.Value));
}
if (filter.HttpContext.Session["DUserName"] == null)
{
ReloadInfoUser();
}
}
string DUser = Auth.GetCookie("DUser");
/// Kiểm tra các lỗi xảy ra
/// Nếu không đúng phân vùng Area: Thông báo lỗi 404
if (Areas != "" && AreaName != Areas.ToLower())
{
filter.HttpContext.Session["ErrorHttp"] = filter.HttpContext.Request.RawUrl;
filter.Result = new RedirectResult(DDefault.Path404);
return;
}
/// Nếu chưa đăng nhập
/// Chuyển về trang đăng nhập
if (DUser == null)
{
filter.HttpContext.Session["returnUrl"] = filter.HttpContext.Request.RawUrl;
filter.Result = new RedirectResult(DDefault.PathLogin);
return;
}
/// Đặc quyền cho SUPERADMIN
if (DUser == DDefault.SAdminID)
{
filter.HttpContext.Session["ErrorHttp"] = "";
filter.HttpContext.Session["returnUrl"] = "";
if (!IsNotLayout)
{
IsNotLayout = false;
LoadBreadcrumb(filter);
LoadMenuLeft(filter);
}
base.OnActionExecuting(filter);
return;
}
DBAdmin db = new DBAdmin();
int? GroupId = int.Parse(Auth.GetCookie("DGroupId")) as int?;
tbMenuInGroup tbMenuInGroup = new tbMenuInGroup(db.tbMenus.Where(p => p.IsDisable == false && p.Controller.ToLower() == ControllerName && p.Action.ToLower() == ActionName).FirstOrDefault(), GroupId.Value);
if (tbMenuInGroup.IsIn)
{
/// Trường hợp thỏa các điều kiện
filter.HttpContext.Session["ErrorHttp"] = "";
filter.HttpContext.Session["returnUrl"] = "";
if (!IsNotLayout)
{
IsNotLayout = false;
LoadBreadcrumb(filter);
LoadMenuLeft(filter);
}
base.OnActionExecuting(filter);
return;
}
else
{
/// Nếu tài khoản không đủ quyền
/// Chuyển về trang thông báo quyền truy cập hoặc 404
HttpContext.Current.Session["ErrorHttp"] = filter.HttpContext.Request.RawUrl;
filter.Result = new RedirectResult(DDefault.PathAccessDenied);
return;
}
}
