protected void Page_Load(object sender, EventArgs e) { string strData = "-1"; try { if (Session[Utils.session_sinhvien] == null) { strData = "NotAuthenticated"; } else { nuce.web.model.SinhVien m_SinhVien = (nuce.web.model.SinhVien)Session[Utils.session_sinhvien]; if (((Request.QueryString["ID"] != null) && (Request.QueryString["Type"] != null)) || ((Request.Form["ID"] != null) && (Request.Form["Type"] != null))) { int iID = -1; string Ma = ""; int Type = -1; if (Request.QueryString["ID"] != null) { iID = int.Parse(Request.QueryString["ID"]); Type = int.Parse(Request.QueryString["Type"]); } else { iID = int.Parse(Request.Form["ID"]); Type = int.Parse(Request.Form["Type"]); } // Cap nhat string sql = ""; if (nuce.web.data.DataUtils.LoaiDichVuSinhViens.ContainsKey(Type)) { sql = string.Format(@" update [dbo].[{0}] set Deleted=1,DeletedBy=@Param0,DeletedTime=getdate() where ID=@Param1 and Status=1; select 1; ", nuce.web.data.DataUtils.LoaiDichVuSinhViens[Type].Param1); } SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@Param0", m_SinhVien.SinhVienID); sqlParams[1] = new SqlParameter("@Param1", iID); strData = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(Nuce_Common.ConnectionString, CommandType.Text, sql, sqlParams).ToString(); } } } catch (Exception ex) { strData = ex.Message; } Response.Clear(); Response.ContentType = "text/plain"; Response.Write(strData); }
protected override void OnInit(EventArgs e) { if (Session[Utils.session_sinhvien] == null) { //Chuyển đến trang đăng nhập Response.Redirect(string.Format("/Login.aspx")); } else { m_SinhVien = (nuce.web.model.SinhVien)Session[Utils.session_sinhvien]; } base.OnInit(e); }
protected override void OnLoad(EventArgs e) { if (!Page.IsPostBack) { if (Session[nuce.web.Utils.session_sinhvien] == null) { divLinkInfo.InnerHtml = ""; } else { nuce.web.model.SinhVien SinhVien = (nuce.web.model.SinhVien)Session[nuce.web.Utils.session_sinhvien]; divLinkInfo.InnerHtml = string.Format("<div id='userLogin' class='fr'><span>Xin chào: {0} - {1} (<a href='/tabid/121/default.aspx?dieukhien=logout'>Thoát</a> - <a href='/tabid/121/default.aspx'>Đổi mật khẩu</a>)</span></div>", SinhVien.Ho, SinhVien.Ten); } } base.OnLoad(e); }
protected void btnDangNhap_Click(object sender, EventArgs e) { string strMaSV = txtMaDangNhap.Text.Trim(); string strMatKhau = txtMatKhau.Text.Trim(); if (strMaSV == "" || strMatKhau == "") { spAlert.InnerHtml = string.Format(@"<div class='alert alert-warning alert-dismissible' style='position: absolute; top: 0; right: 0;'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> {0}</div>", "Bạn không được để trắng tên đăng nhập hoặc mật khẩu"); return; } //Kiểm tra đăng nhập Service sv = new Service(); services_direct.Service sv_1 = new services_direct.Service(); int iTypeDichVu = -1; try { if (sv.authen(strMaSV, strMatKhau) <= 0) { spAlert.InnerHtml = string.Format(@"<div class='alert alert-warning alert-dismissible' style='position: absolute; top: 0; right: 0;'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> {0}</div>", "Thông tin đăng nhập sai"); return; } iTypeDichVu = 1; } catch (Exception ex) { try { if (sv_1.authen(strMaSV, strMatKhau) <= 0) { spAlert.InnerHtml = string.Format(@"<div class='alert alert-warning alert-dismissible' style='position: absolute; top: 0; right: 0;'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> {0}</div>", "Thông tin đăng nhập sai"); return; } iTypeDichVu = 2; } catch (Exception ex1) { iTypeDichVu = 999; } } //string strSql = string.Format("SELECT * FROM [dbo].[AS_Academy_Student] where Code='{0}'", strMaSV); string strSql = string.Format("SELECT * FROM [dbo].[AS_Academy_Student] where Code=@Param1 ;"); strSql += string.Format(@"INSERT INTO [dbo].[AS_Logs] ([UserId] ,[UserCode] ,[Status] ,[Code] ,[Message] ,[CreatedTime]) VALUES (-1 ,'{0}' ,1 ,'LOGIN' ,'{2}' ,'{1}') ;", strMaSV, DateTime.Now, iTypeDichVu); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@Param1", strMaSV); //sqlParams[0].ParameterName = "@Param1"; //sqlParams[0].SqlDbType = SqlDbType.VarChar; //sqlParams[0].Value = strMaSV; DataTable dtData = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(nuce.web.data.Nuce_Common.ConnectionString, CommandType.Text, strSql, sqlParams).Tables[0]; if (dtData != null && dtData.Rows.Count > 0) { nuce.web.model.SinhVien SinhVien = new nuce.web.model.SinhVien(); string strFullName = dtData.Rows[0]["FulName"].ToString(); string[] strFullNames = strFullName.Split(new char[] { ' ' }); SinhVien.Ho = strFullName; SinhVien.Ten = strFullNames[strFullNames.Length - 1]; //SinhVien.TrangThai = int.Parse(dtData.Rows[0]["status"].ToString()); SinhVien.SinhVienID = int.Parse(dtData.Rows[0]["ID"].ToString()); SinhVien.Email = dtData.Rows[0].IsNull("EmailNhaTruong") ? "" : dtData.Rows[0]["EmailNhaTruong"].ToString(); SinhVien.Mobile = dtData.Rows[0]["Mobile"].ToString(); SinhVien.MaSV = dtData.Rows[0]["Code"].ToString(); string File1 = dtData.Rows[0].IsNull("File1") ? "" : dtData.Rows[0]["File1"].ToString(); if (!File1.Trim().Equals("")) { SinhVien.IMG = File1; } else { SinhVien.IMG = "/Data/images/noimage_human.png"; } Session[Utils.session_sinhvien] = SinhVien; Response.Redirect("/DichVuSinhVien.aspx"); } else { spAlert.InnerHtml = string.Format(@"<div class='alert alert-warning alert-dismissible' style='position: absolute; top: 0; right: 0;'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> {0}</div>", "Không tồn tại dữ liệu sinh viên"); } }
public void GetuserProfile(string accesstoken) { string url = "https://www.googleapis.com/oauth2/v2/userinfo?alt=json&access_token=" + accesstoken + ""; WebRequest request = WebRequest.Create(url); request.Credentials = CredentialCache.DefaultCredentials; WebResponse response = request.GetResponse(); Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); string responseFromServer = reader.ReadToEnd(); reader.Close(); response.Close(); JavaScriptSerializer js = new JavaScriptSerializer(); Userclass userinfo = js.Deserialize <Userclass>(responseFromServer); //txtMaDangNhap.Text = userinfo.email; //string strMaSV = txtMaDangNhap.Text.Trim(); //string strSql = string.Format("SELECT * FROM [dbo].[AS_Academy_Student] where Code='{0}'", strMaSV); string strSql = string.Format("SELECT * FROM [dbo].[AS_Academy_Student] where EmailNhaTruong=@Param1 and DaXacThucEmailNhaTruong=1"); strSql += string.Format(@"INSERT INTO [dbo].[AS_Logs] ([UserId] ,[UserCode] ,[Status] ,[Code] ,[Message] ,[CreatedTime]) VALUES (-1 ,'{0}' ,1 ,'LOGIN' ,'{2}' ,'{1}') ;", userinfo.email, DateTime.Now, 3); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@Param1", userinfo.email); //sqlParams[0].ParameterName = "@Param1"; //sqlParams[0].SqlDbType = SqlDbType.VarChar; //sqlParams[0].Value = strMaSV; DataTable dtData = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(nuce.web.data.Nuce_Common.ConnectionString, CommandType.Text, strSql, sqlParams).Tables[0]; if (dtData != null && dtData.Rows.Count > 0) { nuce.web.model.SinhVien SinhVien = new nuce.web.model.SinhVien(); string strFullName = dtData.Rows[0]["FulName"].ToString(); string[] strFullNames = strFullName.Split(new char[] { ' ' }); SinhVien.Ho = strFullName; SinhVien.Ten = strFullNames[strFullNames.Length - 1]; //SinhVien.TrangThai = int.Parse(dtData.Rows[0]["status"].ToString()); SinhVien.SinhVienID = int.Parse(dtData.Rows[0]["ID"].ToString()); SinhVien.Email = dtData.Rows[0].IsNull("EmailNhaTruong") ? "" : dtData.Rows[0]["EmailNhaTruong"].ToString(); SinhVien.Mobile = dtData.Rows[0]["Mobile"].ToString(); SinhVien.MaSV = dtData.Rows[0]["Code"].ToString(); string File1 = dtData.Rows[0].IsNull("File1") ? "" : dtData.Rows[0]["File1"].ToString(); if (!File1.Trim().Equals("")) { SinhVien.IMG = File1; } else { SinhVien.IMG = "/Data/images/noimage_human.png"; } Session[Utils.session_sinhvien] = SinhVien; Response.Redirect("/DichVuSinhVien.aspx"); } else { spAlert.InnerHtml = string.Format(@"<div class='alert alert-warning alert-dismissible' style='position: absolute; top: 0; right: 0;'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> {0}</div>", "Không đúng tên đăng nhập"); } //Kiem tra ho ten xem co trung khong sau do lay trong csdl //imgprofile.ImageUrl = userinfo.picture; //lblid.Text = userinfo.id; //lblgender.Text = userinfo.gender; //lbllocale.Text = userinfo.locale; //lblname.Text = userinfo.name; //hylprofile.NavigateUrl = userinfo.link; }
protected void Page_Load(object sender, EventArgs e) { if (Session[Utils.session_sinhvien] == null) { //Chuyển đến trang đăng nhập Response.Redirect(string.Format("/Login.aspx")); } else { nuce.web.model.SinhVien SinhVien = (nuce.web.model.SinhVien)Session[Utils.session_sinhvien]; spNameUser.InnerHtml = string.Format("{0} - {1}", SinhVien.Ho, SinhVien.MaSV); imgUser.Src = SinhVien.IMG; string strNav = @"<a class='sidebar-brand d-flex align-items-center justify-content-center' href = '/dichvusinhvien'> <div class='sidebar-brand-icon rotate-n-15'> <i class='fas fa-laugh-wink'></i> </div> <div class='sidebar-brand-text mx-3'>Dashboard</div> </a> <hr class='sidebar-divider my-0' />"; string URL = Request.RawUrl.ToUpper(); if (URL.Contains("DICHVU"))//dichvusinhvien { strNav += string.Format(@"<li class='nav-item active'> <a class='nav-link' href='/dichvusinhvien'> <i class='fas fa-tools'></i> <span>Thủ tục hành chính</span> </a> </li><hr class='sidebar-divider'/>"); } else { strNav += string.Format(@"<li class='nav-item'> <a class='nav-link' href='/dichvusinhvien'> <i class='fas fa-tools'></i> <span>Thủ tục hành chính</span> </a> </li><hr class='sidebar-divider'/>"); } // if (URL.Contains("DEFAULT") || URL.Contains("CHITIETBAITIN")) // strNav += string.Format(@"<li class='nav-item active'> //<a class='nav-link' href='/default'> // <i class='fas fa-home'></i> // <span>Trang chủ</span></a> // </li> <hr class='sidebar-divider'/>"); // else // strNav += string.Format(@"<li class='nav-item'> //<a class='nav-link' href='/default'> // <i class='fas fa-home'></i> // <span>Trang chủ</span></a> // </li> <hr class='sidebar-divider'/>"); if (URL.Contains("HOSOSINHVIEN")) ///hososinhvien { strNav += string.Format(@"<li class='nav-item active'> <a class='nav-link' href='/hososinhvien'> <i class='fas fa-address-book'></i> <span>Hồ sơ</span> </a> </li>"); } else { strNav += string.Format(@"<li class='nav-item'> <a class='nav-link' href='/hososinhvien'> <i class='fas fa-address-book'></i> <span>Hồ sơ</span> </a> </li>"); } if (URL.Contains("CAPNHATHOSO")) ///capnhathoso { strNav += string.Format(@"<li class='nav-item active'> <a class='nav-link' href='/capnhathoso'> <i class='fas fa-user-edit'></i> <span>Cập nhật hồ sơ</span> </a></li>"); } else { strNav += string.Format(@"<li class='nav-item'> <a class='nav-link' href='/capnhathoso'> <i class='fas fa-user-edit'></i> <span>Cập nhật hồ sơ</span> </a> </li>"); } if (URL.Contains("DEFAULT") || URL.Contains("CHITIETBAITIN")) { strNav += string.Format(@"<li class='nav-item active'> <a class='nav-link' href='/default'> <i class='fas fa-newspaper'></i> <span>Thông báo</span></a> </li> "); } else { strNav += string.Format(@"<li class='nav-item'> <a class='nav-link' href='/default'> <i class='fas fa-newspaper'></i> <span>Thông báo</span></a> </li> "); } accordionSidebar.InnerHtml = strNav; } }