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