public object deleteGroup(int id_group) { { SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); try { Conds.Add("ID_GROUP", id_group); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Delete(Conds, "TBL_GROUP") < 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 Delete_User(int id_group, int id_user) { 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 = ""; try { Conds.Add("ID_GROUP", id_group); Conds.Add("ID_USER", id_user); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Delete(Conds, "TBL_GROUPMEMBER") < 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 deleteMedia(int id_media) { { SqlConditions Conds = new SqlConditions(); SqlConditions Conds_tb = new SqlConditions(); DataTable dt = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); try { Conds_tb.Add("ID_MEDIA", id_media); using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true)) { //cnn.Delete(Conds_tb, "TBL_THONGBAO"); Thread.Sleep(500); if (cnn.Delete(Conds_tb, "TBL_MEDIA") < 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 UpdateTrangCaNhan(Models.TrangCaNhan data) { { 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("TieuSu", data.tieusu); Conds.Add("ID_CANHAN", data.id_canhan); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Update(val, Conds, "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 deleteBaiTrangCaNhan(int id_baidangcanhan) { { SqlConditions Conds = new SqlConditions(); SqlConditions Conds_tb = new SqlConditions(); DataTable dt = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); try { val.Add("COL_DISABLE", true); Conds.Add("ID_BAIDANG_CANHAN", id_baidangcanhan); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Update(val, Conds, "TBL_BaiDang_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 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 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 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 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 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 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 addGhim(int id_user, int id_thongdiep) { { int status = 0; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; Hashtable val = new Hashtable(); Hashtable val2 = new Hashtable(); DataTable dt_token = new DataTable(); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); //val.Add("ID_COMMENT", data.id_cmt); // val.Add("ID_BAIDANG", data.ID_BaiDang); //val.Add("ID_THONGDIEP", id_thongdiep); //val.Add("COL_DISABLE", true); //val.Add("ID_USER", id_user); val2.Add("COL_DISABLE", true); //Conds.Add("ID_USER", id_user); Conds.Add("ID_THONGDIEP", id_thongdiep); //Conds.Add("ID_USER", data.ID_User); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { // dt = cnn.CreateDataTable(@"SELECT COL_DISABLE FROM TBL_THONGDIEPCEO as g where g.ID_THONGDIEP="+id_thongdiep, Conds); // dr = dt.Select(); // var total = dt.Rows.Count; if (cnn.Update(val2, Conds, "TBL_THONGDIEPCEO") < 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 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 async Task <BaseModel <object> > Logout() { string Token = lc.GetHeader(Request); var user = lc._GetInfoUser(Token); if (user == null) { return(JsonResultCommon.DangNhap()); } logHelper.Log(5, user.Id, "Đăng xuất"); return(JsonResultCommon.ThanhCong()); }
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 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 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 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 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 BaseModel <object> ResetSession() { BaseModel <object> _baseModel = new BaseModel <object>(); string Token = lc.GetHeader(Request); var user = lc._GetInfoUser(Token); if (user == null) { return(JsonResultCommon.DangNhap()); } var reset = lc.RefreshJSONWebToken(ref user); user.accessToken = reset; return(JsonResultCommon.ThanhCong(user)); }
public object UpdateQuyenLoaiBaiDang(int loai) { { 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; Hashtable val = new Hashtable(); List <object> rs = new List <object>(); string title = "", link = ""; DataTable dt_token = new DataTable(); try { //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { val.Add("ID_LOAIBAIDANG", loai); val.Add("ID_USER", loginData.Id); if (cnn.Insert(val, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 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 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 UpdateGhim(int id_user, int id_thongdiep) { int status = 0; string Id = ""; int id_group = 0; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; Hashtable val = new Hashtable(); Hashtable val_member = new Hashtable(); DataTable dt_token = new DataTable(); DataTable lastid = new DataTable(); string sqlq = ""; try { using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true)) { val.Add("COL_DISABLE", false); Conds.Add("ID_THONGDIEP", id_thongdiep); if (cnn.Update(val, Conds, "TBL_THONGDIEPCEO") < 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 UpdateThongDiep(Models.ThongDiepCEO data) { int status = 0; string Id = ""; int id_group = 0; string Token = ""; SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); DataRow[] dr; bool Visible = true; List <object> rs = new List <object>(); string title = "", link = ""; Hashtable val = new Hashtable(); Hashtable val_member = new Hashtable(); DataTable dt_token = new DataTable(); DataTable lastid = new DataTable(); string sqlq = ""; try { using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { val.Add("TIEUDE", data.title); val.Add("NOIDUNG", data.noidung); Conds.Add("ID_THONGDIEP", data.id_thongdiep); if (cnn.Update(val, Conds, "TBL_THONGDIEPCEO") < 0) { return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError)); } } return(JsonResultCommon.ThanhCong()); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } }