/// <summary> /// reset mật khẩu /// </summary> /// <param name="iduser"></param> /// <param name="password"></param> /// <returns></returns> //public string ResetPass(string iduser, string password) //{ // using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) // { // var Tb = Conn.CreateDataSet(@"select * from Dps_User where UserID = @Id // select * from Sys_Config where Code='SEND_MAIL_RESET_PASS'", new SqlConditions() { { "Id", iduser } }); // if (Tb == null || Tb.Tables[0].Rows.Count != 1) // return "Tài khoản không tồn tại"; // string newpass = EncryptPassword(password); // var val = new Hashtable(); // val.Add("PasswordHash", newpass); // val.Add("LastUpdatePass", DateTime.Now); // val.Add("GiaHan", 0); // Conn.BeginTransaction(); // if (Conn.Update(val, new SqlConditions { new SqlCondition("UserID", iduser) }, "Dps_User") != 1) // { // Conn.RollbackTransaction(); // return "Không thể thay đổi mật khẩu"; // } // #region gửi mail // try // { // if (Tb.Tables[1].Rows.Count > 0) // { // if (Tb.Tables[1].Rows[0]["Value"].ToString() == "1") // { // if (string.IsNullOrEmpty(Tb.Tables[0].Rows[0]["Email"].ToString())) // { // Conn.RollbackTransaction(); // return "Không thể thay đổi mật khẩu";// "Người dùng không có thông tin Email"; // } // string Error = ""; // //string strHTML = System.IO.File.ReadAllText(_config.LinkAPI + Constant.TEMPLATE_IMPORT_FOLDER + "/User_ForgetPass.html"); // Hashtable kval = new Hashtable(); // kval.Add("{{NewPass}}", password); // kval.Add("$nguoinhan$", Tb.Tables[0].Rows[0]["Fullname"]); // kval.Add("$SysName$", _config.SysName); // MailAddressCollection Lstcc = new MailAddressCollection(); // MailInfo minfo = new MailInfo(MailConfig.Value, int.Parse(Tb.Tables[0].Rows[0]["IdDonVi"].ToString())); // if (minfo.Id > 0) // { // string fileTemp = Path.Combine(_hostingEnvironment.ContentRootPath, Constant.TEMPLATE_IMPORT_FOLDER + "/User_ForgetPass.html"); // var rs = SendMail.Send(fileTemp, kval, Tb.Tables[0].Rows[0]["Email"].ToString(), "RESET MẬT KHẨU NGƯỜI DÙNG", Lstcc, Lstcc, null, false, out Error, minfo); // if (!string.IsNullOrEmpty(Error)) // { // Conn.RollbackTransaction(); // return "Không thể thay đổi mật khẩu";//"Gửi mail thất bại"; // } // } // } // } // } // catch (Exception ex) // { // Conn.RollbackTransaction(); // return "Không thể thay đổi mật khẩu";// "Gửi mail thất bại"; // } // #endregion // Conn.EndTransaction(); // return ""; // } //} /// <summary> /// kiểm tra người dùng có tồn tại /// </summary> /// <param name="UserNameorID">id người dùng hoặc tên đăng nhập</param> /// <param name="loai">0: kiểm tra bằng ID, 1: username</param> /// <returns></returns> public bool CheckNguoiDung(string UserNameorID, int loai) { DataTable Tb = null; using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) { SqlConditions sqlcond = new SqlConditions(); string sqlq = ""; if (loai == 1) { sqlcond.Add("UserName", UserNameorID); sqlq = "select [UserID] from Dps_User where Deleted = 0 and UserName = @UserName"; } if (loai == 0) { sqlcond.Add("Id", UserNameorID); sqlq = "select [UserID] from Dps_User where Deleted = 0 and UserID = @Id"; } Tb = Conn.CreateDataTable(sqlq, sqlcond); } if (Tb.Rows.Count == 1) { return(true); } return(false); }
/// <summary> /// kiểm tra email người dùng có tồn tại /// </summary> /// <param name="email">email</param> /// <param name="UserId">0: khi insert, 1: khi update</param> /// <returns></returns> public bool CheckEmail(string email, long UserId) { DataTable Tb = null; using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) { SqlConditions sqlcond = new SqlConditions(); string sqlq = ""; string idstr = ""; sqlcond.Add("email", email); if (UserId > 0) { idstr = " and UserID <> @Id"; sqlcond.Add("Id", UserId); } sqlq = $"select [UserID] from Dps_User where Deleted = 0 {idstr} and Email=@email"; Tb = Conn.CreateDataTable(sqlq, sqlcond); } if (Tb.Rows.Count == 1) { return(true); } return(false); }
/// <summary> /// Lấy danh sách nhóm quyền của nhóm người dùng /// </summary> /// <param name="group"></param> /// <returns></returns> public Dictionary <int, List <int> > GetGroupRole_Roles(List <int> group) { Dictionary <int, List <int> > dic = new Dictionary <int, List <int> >(); using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) //db QLPA { for (int i = 0; i < group.Count; i++) { int idusergroup = group[i]; string sql = @"select g.IDGroupUser,g.IDGroupRole,r.RoleGroupName from Dps_RoleGroups r inner join Dps_UserGroupRoles g on g.IDGroupRole=r.GroupID where IDGroupUser=@IDGroupUser"; DataTable dt = Conn.CreateDataTable(sql, new SqlConditions { { "IDGroupUser", idusergroup } }); if (Conn.LastError != null || dt == null) { return(null); } var slist = new List <int>(); foreach (DataRow r in dt.Rows) { slist.Add(int.Parse(r["IDGroupRole"].ToString())); } dic.Add(idusergroup, slist); } } return(dic); }
/// <summary> /// đổi mật khẩu /// </summary> /// <param name="iduser">id người dùng</param> /// <param name="oldpassword">mật khẩu cũ</param> /// <param name="password">mật khẩu mới</param> /// <returns></returns> public BaseModel <object> ChangePass(string iduser, string oldpassword, string password) { if (string.IsNullOrEmpty(password) || password.Length < 6) { return(JsonResultCommon.Custom("Mật khẩu mới quá ngắn")); } using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) { var Tb = Conn.CreateDataTable("select PasswordHash from Dps_User where UserID = @Id", new SqlConditions() { { "Id", iduser } }); if (Tb == null || Tb.Rows.Count != 1) { return(JsonResultCommon.KhongTonTai()); } if (!oldpassword.Equals(DecryptPassword(Tb.Rows[0]["PasswordHash"].ToString()))) { return(JsonResultCommon.Custom("Mật khẩu cũ không chính xác")); } string newpass = EncryptPassword(password); var val = new Hashtable(); val.Add("PasswordHash", newpass); val.Add("LastUpdatePass", DateTime.Now); val.Add("GiaHan", 0); if (Conn.Update(val, new SqlConditions { new SqlCondition("UserID", iduser) }, "Dps_User") != 1) { return(JsonResultCommon.SQL(Conn.LastError.Message)); } return(JsonResultCommon.ThanhCong()); } }
/// <summary> /// Lấy danh sách nhóm người dùng /// </summary> /// <param name="IdUser"></param> /// <returns></returns> public List <int> GetUserGroup(string IdUser) { DataTable Tb = null; using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) //db QLPA { string sqlq = @"select distinct a.IdUser,b.IdGroup,b.GroupName from Tbl_User_GroupUser a inner join Dps_User u on a.IdUser=a.IdUser inner join Dps_UserGroups b on b.IdGroup=a.IdGroupUser where a.IdUser=@IdUser "; //string sqlq = "exec [spn_GetRoleByUser] @UserID"; Tb = Conn.CreateDataTable(sqlq, new SqlConditions() { { "IdUser", IdUser } }); if (Conn.LastError != null || Tb == null) { return(null); } } var slist = new List <int>(); foreach (DataRow r in Tb.Rows) { slist.Add(int.Parse(r["IdGroup"].ToString())); } return(slist); }
/// <summary> /// Chỉ lấy tất cả quyền của user /// </summary> /// <param name="IdUser"></param> /// <returns></returns> public List <long> GetRules(long IdUser, int VaiTro) { DataTable Tb = null; using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) { string sqlq = @"select distinct ug.IdUser,r.IdRole,r.Role from Dps_User_GroupUser ug inner join Dps_UserGroupRoles gr on gr.IDGroupUser=ug.IdGroupUser inner join Dps_Roles r on r.IdRole=gr.IDGroupRole where ug.IdUser=@UserID and r.Disabled=0"; sqlq += " and ug.Locked=0 and ug.Disabled=0 and ug.IdGroupUser=@VaiTro"; //string sqlq = "exec [spn_GetRoleByUser] @UserID"; Tb = Conn.CreateDataTable(sqlq, new SqlConditions() { { "UserID", IdUser }, { "VaiTro", VaiTro } }); if (Tb == null) { return(null); } } var slist = new List <long>(); foreach (DataRow r in Tb.Rows) { slist.Add(long.Parse(r["IdRole"].ToString())); } return(slist); }
public bool ktma(string ma) { DataTable dt_user = new DataTable(); DataRow[] dr; SqlConditions Conds = new SqlConditions(); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt_user = cnn.CreateDataTable(@" select Email from TBL_Account ", Conds); dr = dt_user.Select(); for (int i = 0; i < dt_user.Rows.Count; i++) { if (dt_user.Rows[i]["Email"].ToString() == ma) { return(true); } } return(false); //var nv = qlks.TAIKHOANs.Where(t => t.TENTK == ma).FirstOrDefault(); //if (nv == null) //{ // return false; //} //return true; } }
public bool LogImport(long idUser, string text = "") { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { DataTable dt = cnn.CreateDataTable("select * from Tbl_Log_Loai where IdRow=" + Loai); if (dt == null || dt.Rows.Count == 0) { Error = "Loại đối tượng không đúng"; return(false); } string ip = _accessor.HttpContext.Connection.RemoteIpAddress.ToString(); Hashtable val = new Hashtable(); val.Add("IdLoaiLog", Loai); val.Add("IdHanhDong", 7); val.Add("IP", ip); val.Add("NoiDung", "Import danh sách " + dt.Rows[0]["LoaiLog"].ToString().ToLower() + " " + text); val.Add("CreatedBy", idUser); val.Add("CreatedDate", DateTime.Now); int kq = cnn.Insert(val, "Tbl_Log"); cnn.Disconnect(); if (kq == 1) { return(true); } else { return(false); } } }
public object getTrangCaNhanFlow(int id_user) { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int status = 0; string Id = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" select distinct ID_CANHAN,u.ID_USER,AnhBia,UserName,AVATAR,TieuSu from TBL_TRANGCANHAN as cn, TBL_Account as u where cn.ID_USER=u.ID_USER and u.ID_USER="******"ID_CANHAN"], Id_user = g["ID_USER"], hinhanhbia = g["AnhBia"], tieusu = g["TieuSu"], anhbia = LiteController.genLinkImage_Post(_config.LinkAPI, g["AnhBia"]), //media = g["TYPEPOST"], //imgmedia = $"{link}/UploadedFiles/{g["TYPEPOST"]}", //id_user = r["ID_USER"], user_name = g["UserName"], hinhanh = g["AVATAR"], Avatar = LiteController.genLinkAvatar(_config.LinkAPI, g["AVATAR"]), }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public object GetUpdateQuyenLoaiBaiDang() { { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int status = 0; string Id = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { Conds.Add("id_user", loginData.Id); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { link = "http://192.168.43.236/"; // link = "http://192.168.3.49/"; //link = "https://*****:*****@id_user", Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dt = cnn.CreateDataTable(@"SELECT ID_LOAIBAIDANG,TENLOAIBAIDANG FROM TBL_LOAIBAIDANG EXCEPT SELECT lbd.ID_LOAIBAIDANG,TENLOAIBAIDANG FROM TBL_NHOM_QUYEN_LOAIBAIDANG as lbd,TBL_LOAIBAIDANG as bd WHERE ID_USER=@id_user and lbd.ID_LOAIBAIDANG=bd.ID_LOAIBAIDANG ", Conds); } var data = from r in dt.AsEnumerable() select new { Id_LoaiDang = r["ID_LOAIBAIDANG"], TenLoaiDang = r["TENLOAIBAIDANG"], check = false, }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetDSNhanVien_PB(int id_phong) { { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; string sql = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); sql = @" select IDNV,pb.ID_PHONG,TENPHONG,CHUCVU,HOTEN,DIACHI,NGAYSINH,SDT,GIOITINH,NGAYVAOLAM from TBL_NHANVIEN as nv ,TBL_PHONGBAN as pb where nv.ID_PHONG=pb.ID_PHONG "; using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(sql, Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dr = dt.Select(); } var data = from r in dr.AsEnumerable() where r["ID_PHONG"].Equals(id_phong) select new { id_NV = r["IDNV"], id_phong = r["ID_PHONG"], hoten = r["HOTEN"], chucvu = r["CHUCVU"], diachi = r["DIACHI"], ngaysinh = r["NGAYSINH"], sdt = r["SDT"], gioitinh = r["GIOITINH"], // Roles = r["roles"], tenphong = r["TENPHONG"], ngayvaolam = r["NGAYVAOLAM"], //Occupation = r["occupation"], //Phoned = r["Phone"], //Address = r["Address"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetLuuTruKhenThuongUser() { { int status = 0; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { string sql = @" select bd.ID_BAIDANG,bd.TIEUDE,bd.NOIDUNG_BAIDANG,bd.CreatedDate,bd.CreatedBy,kt.TIEUDE AS TIEUDE_KT,kt.LINK_ICON,u.UserName,u.AVATAR from TBL_BAIDANG as bd,TBL_KHENTHUONG as kt,TBL_Account as u where bd.ID_KHENTHUONG is not null and bd.ID_KHENTHUONG=kt.ID_KHENTHUONG and bd.CreatedBy=u.ID_USER "; dt = cnn.CreateDataTable(sql, Conds); dr = dt.Select(); } var data = from r in dr.AsEnumerable() select new { Id_BaiDang = r["ID_BAIDANG"], tieude_baidang = r["TIEUDE"], noidungbaidang = r["NOIDUNG_BAIDANG"], createdate = r["CreatedDate"], createby = r["CreatedBy"], tieude_kt = r["TIEUDE_KT"], icon_kt = r["LINK_ICON"], user_name = r["UserName"], hinhanh = r["AVATAR"], avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]), }; return(JsonResultCommon.ThanhCong(data)); //ID_khenthuong = r["ID_KHENTHUONG"], //tieude = r["TIEUDE"], //icon = r["LINK_ICON"], //Noidungkt = r["NOIDUNG_KHEN_THUONG"], //user_KT = r["USER_KT"], } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetDSUser_filter_InGroup(int id_gr) { { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { link = "http://192.168.43.236/"; //link = "http://192.168.3.49/"; // link = "https://*****:*****@"SELECT ID_USER,UserName,AVATAR FROM TBL_Account EXCEPT select u.ID_USER,u.UserName,AVATAR from TBL_GROUPMEMBER as gm ,TBL_Account as u where GM.ID_USER=U.ID_USER and ID_GROUP=" + id_gr + "", Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dr = dt.Select(); } var data = from r in dr.AsEnumerable() select new { ID_user = r["ID_USER"], Username = r["UserName"], // Roles = r["roles"], hinhanh = r["AVATAR"], Avatar = $"{link}/Avatar/{ r["AVATAR"]}", //Occupation = r["occupation"], //Phoned = r["Phone"], //Address = r["Address"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object getGioiThieu() { int status = 0; string Id = ""; string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" select ID_USER,u.IDNV,HOTEN,CHUCVU,DIACHI from TBL_Account as u , TBL_NHANVIEN as nv where u.IDNV=nv.IDNV and ID_USER="******"ID_USER"], Id_nv = g["IDNV"], hoten = g["HOTEN"], //media = g["TYPEPOST"], //imgmedia = $"{link}/UploadedFiles/{g["TYPEPOST"]}", //id_user = r["ID_USER"], chucvu = g["CHUCVU"], diachi = g["DIACHI"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public object GetDSUser_In_Group(int id_group) { { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt_group = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt_group = cnn.CreateDataTable(@" select ID_GROUP, U.ID_USER, QUYEN_ADMIN , CREATE_DATE, IDNV, UserName, AVATAR from TBL_GROUPMEMBER AS G, TBL_Account AS U WHERE G.ID_USER = U.ID_USER and QUYEN_ADMIN=0 and ID_GROUP=" + id_group , Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); } var data = from r in dt_group.AsEnumerable() select new { Id_group = r["ID_GROUP"], id_user = r["ID_USER"], id_nv = r["IDNV"], Username = r["UserName"], quyen_group = r["QUYEN_ADMIN"], create_date = r["CREATE_DATE"], // Roles = r["roles"], //Address = r["Address"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetDSKhenThuongUser() { { int status = 0; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { link = "http://192.168.3.49/"; string sql = @" select tk.ID_KHENTHUONG,NOIDUNG_KHEN_THUONG,TIEUDE,LINK_ICON,HOTEN from TBL_KHENTHUONG_USER as tk, TBL_Account as u,TBL_NHANVIEN as nv,TBL_KHENTHUONG as t where tk.USER_KT=u.ID_USER and u.IDNV=nv.IDNV and tk.ID_KHENTHUONG=t.ID_KHENTHUONG "; dt = cnn.CreateDataTable(sql, Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dr = dt.Select(); //foreach (DataRow r in dr) //{ // if (File.Exists(HttpContext.Current.Server.MapPath($"~/image/User/{r["ID_USER"]}.jpg"))) // { // r["AVATAR"] = link + $"image/User/{r["ID_USER"]}.jpg"; // } //} } var data = from r in dr.AsEnumerable() select new { ID_khenthuong = r["ID_KHENTHUONG"], noidung_kt = r["NOIDUNG_KHEN_THUONG"], tieude = r["TIEUDE"], hoten = r["HOTEN"], icon = r["LINK_ICON"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object getDSThongDiepDetail(int id_td) { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" select ID_THONGDIEP,TIEUDE,NOIDUNG,TYPEPOST,CreatedBy,CreatedDate,HOTEN,CHUCVU,AVATAR,COL_DISABLE from TBL_THONGDIEPCEO as td , TBL_USER as u,TBL_NHANVIEN as nv where u.ID_USER=td.CreatedBy and u.IDNV=nv.IDNV and ID_THONGDIEP=" + id_td, Conds); } var data = from g in dt.AsEnumerable() select new { id_thongdiep = g["ID_THONGDIEP"], title = g["TIEUDE"], noidung = g["NOIDUNG"], hoten = g["HOTEN"], chucvu = g["CHUCVU"], media = g["TYPEPOST"], ghim = g["COL_DISABLE"], imgmedia = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]), //user_name = r["UserName"], create_by = g["CreatedBy"], createdate = g["CreatedDate"], hinhanh = g["AVATAR"], AlowEdit = g["CreatedBy"], Avatar = LiteController.genLinkAvatar(_config.LinkAPI, g["AVATAR"]), }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public BaseModel <object> GetDSUser_profile_change() { { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int status = 0; string Id = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@"select ID_USER, u.IDNV,TINHTRANG, UserName, AVATAR, Pass, Email, nv.CHUCVU from TBL_Account as u, TBL_NHANVIEN as nv where u.IDNV = nv.IDNV and u.ID_USER="******"select * from LoginSection where Token = @token and Id = @Id_nv", Conds); } var data = from r in dt.AsEnumerable() select new { ID_user = r["ID_USER"], Username = r["UserName"], Password = r["Pass"], Email = r["Email"], chucvu = r["CHUCVU"], hinhanh = r["AVATAR"], Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]), TinhTrang = r["TINHTRANG"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object UpdateUserName(Models.User.Account data) { { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); val.Add("TINHTRANG", data.TinhTrang); Conds.Add("ID_USER", loginData.Id); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Update(val, Conds, "TBL_Account") < 0) { return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError)); } dt = cnn.CreateDataTable("select * from TBL_Account", Conds); } var dl = from r in dt.AsEnumerable() select new { ID_user = r["ID_USER"], ID_NV = r["IDNV"], Username = r["UserName"], Password = r["Pass"], Email = r["Email"], Token = r["Token"], TinhTrang = r["TINHTRANG"], // Roles = r["roles"], Avatar = r["AVATAR"], }; // mangxahoi.PushToAllUsers_CheckOnline(dl, null); return(JsonResultCommon.ThanhCong(dl)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object Create_TrangCanNhan() { { SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; DataTable dt_tb = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); string tam = ""; int id_user = 0; try { //Conds.Add("email", Email); //Conds.Add("password", Pass); //val.Add("ID_COMMENT", data.id_cmt); // val.Add("ID_BAIDANG", data.ID_BaiDang); //Conds.Add("ID_USER", data.ID_User); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt_tb = cnn.CreateDataTable(@"SELECT Max(ID_USER) as asLastID FROM TBL_Account"); dr = dt_tb.Select(); tam = dt_tb.Rows[0]["asLastID"].ToString(); id_user = Int32.Parse(tam); Thread.Sleep(500); val.Add("ID_USER", id_user); if (cnn.Insert(val, "TBL_TRANGCANHAN") < 0) { return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError)); } } return(JsonResultCommon.ThanhCong()); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetPhanQuyenLoaiBaiDang() { { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int status = 0; string Id = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { Conds.Add("id_user", loginData.Id); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { //dt = cnn.CreateDataTable("select * from TBL_NHOM_QUYEN_LOAIBAIDANG, TBL_NHOM_QUYEN_USER, TBL_LOAIBAIDANG where TBL_NHOM_QUYEN_LOAIBAIDANG.ID_QUYEN = TBL_NHOM_QUYEN_USER.ID_QUYEN and TBL_NHOM_QUYEN_LOAIBAIDANG.ID_LOAIBAIDANG = TBL_LOAIBAIDANG.ID_LOAIBAIDANG and ID_USER =@id_user", Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dt = cnn.CreateDataTable("select * from TBL_NHOM_QUYEN_LOAIBAIDANG as qbd,TBL_LOAIBAIDANG as loai where qbd.ID_LOAIBAIDANG = loai.ID_LOAIBAIDANG and ID_USER =@id_user", Conds); dr = dt.Select(); } var data = from r in dr.AsEnumerable() select new { Id_LoaiDang = r["ID_LOAIBAIDANG"], TenLoaiDang = r["TENLOAIBAIDANG"], Icon_BaiDang = r["LINK_ICON_BAIDANG"], Icon_app = r["ICON_APP"], check = true, }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object CheckFlow(int id_canhan) { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int total; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_count = new DataTable(); DataTable dt_user = new DataTable(); DataTable checkflow = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { checkflow = cnn.CreateDataTable(@" select ID_CANHAN from TBL_Flow where USER_Flow=" + loginData.Id + " and ID_CANHAN=" + id_canhan, Conds); } total = checkflow.Rows.Count; if (total > 0) { return(new { check = true }); } else { return(new { check = false }); } } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public object GetUserProfile() { { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } int status = 0; string Id = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" select ID_USER,nv.IDNV,UserName,AVATAR,DIACHI,NGAYSINH,SDT,GIOITINH from TBL_Account as u ,TBL_NHANVIEN as nv where u.IDNV=nv.IDNV and ID_USER="******"ID_USER"], ID_NV = r["IDNV"], Username = r["UserName"], hinhanh = r["AVATAR"], Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]), diachi = r["DIACHI"], ngaysinh = r["NGAYSINH"], sdt = r["SDT"], gioitinh = r["GIOITINH"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object getDSGhim(int id_user) { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" SELECT * FROM TBL_GHIM as g,TBL_THONGDIEPCEO as td where g.ID_THONGDIEP=td.ID_THONGDIEP and ID_USER="******"ID_THONGDIEP"], title = g["TIEUDE"], noidung = g["NOIDUNG"], media = g["TYPEPOST"], imgmedia = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]), //id_user = r["ID_USER"], //user_name = r["UserName"], create_by = g["CreatedBy"], createdate = g["CreatedDate"], //hinhanh = g["AVATAR"], //AlowEdit = g["CreatedBy"], //Avatar = $"{link}/Avatar/{ g["AVATAR"]}", }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public object GetDS_MyMedia(int id_usser) { { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true)) { dt = cnn.CreateDataTable(@" select ID_MEDIA,HINHANH,template,TIEUDE,CreatedBy,CreatedDate,UserName,AVATAR from TBL_MEDIA as me,TBL_Account as u where me.CreatedBy=u.ID_USER and me.CreatedBy=" + id_usser + "order by ID_MEDIA DESC" , Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); } var data = from r in dt.AsEnumerable() select new { id_media = r["ID_MEDIA"], img_media = r["HINHANH"], template = r["template"], hinhanh = LiteController.genLinkImage_Media(_config.LinkAPI, r["HINHANH"]), title = r["TIEUDE"], createdate = r["CreatedDate"], createby = r["CreatedBy"], username = r["UserName"], hinhanh_user = r["AVATAR"], Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]), }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetDSKhenThuong() { { int status = 0; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { link = "http://192.168.3.49/"; dt = cnn.CreateDataTable("select * from TBL_KHENTHUONG", Conds); //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds); dr = dt.Select(); //foreach (DataRow r in dr) //{ // if (File.Exists(HttpContext.Current.Server.MapPath($"~/image/khenthuong/{r["ID_KHENTHUONG"]}.jpg"))) // { // r["ICON_APP"] = link + $"image/khenthuong/{r["ID_KHENTHUONG"]}.jpg"; // } //} } var data = from r in dr.AsEnumerable() select new { ID_khenthuong = r["ID_KHENTHUONG"], tieude = r["TIEUDE"], icon = r["LINK_ICON"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object getRanDoomAnh() { int status = 0; string Id = ""; string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" select TOP 1 * from TBL_BAIDANG where CreatedBy=" + loginData.Id + " and TYPEPOST !=null or TYPEPOST!='' ORDER BY NEWID() ", Conds); } var data = from g in dt.AsEnumerable() select new { img = g["TYPEPOST"], hinhanh = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]), }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }
public object GetRanDomTop2KhenThuong() { { int status = 0; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" SELECT TOP 2 bd.ID_BAIDANG,bd.ID_KHENTHUONG,kt.TIEUDE as kttd,bd.TIEUDE as bdtieude,kt.LINK_ICON FROM TBL_BAIDANG as bd ,TBL_KHENTHUONG as kt where bd.ID_KHENTHUONG=kt.ID_KHENTHUONG and ID_LOAIBAIDANG=2 ORDER BY NEWID() ", Conds); dr = dt.Select(); } var data = from r in dr.AsEnumerable() select new { id_baidang = r["ID_BAIDANG"], ID_khenthuong = r["ID_KHENTHUONG"], tieudekt = r["kttd"], tieudebaidang = r["bdtieude"], icon = r["LINK_ICON"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object GetNVNotUser() { { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" SELECT IDNV,HOTEN FROM TBL_NHANVIEN EXCEPT SELECT u.IDNV,HOTEN FROM TBL_Account as u,TBL_NHANVIEN as nv where u.IDNV=nv.IDNV ", Conds); } var data = from r in dt.AsEnumerable() select new { id_nv = r["IDNV"], hoten = r["HOTEN"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } }
public object getRanDomDSThongDiep() { int status = 0; string Id = ""; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataTable dt_group = new DataTable(); DataTable dt_user = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = ""; DataTable dt_token = new DataTable(); try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { dt = cnn.CreateDataTable(@" SELECT TOP 1 ID_THONGDIEP,TIEUDE,CreatedDate FROM TBL_THONGDIEPCEO ORDER BY NEWID() ", Conds); } var data = from g in dt.AsEnumerable() select new { id_thongdiep = g["ID_THONGDIEP"], title = g["TIEUDE"], createdate = g["CreatedDate"], }; return(JsonResultCommon.ThanhCong(data)); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }