Beispiel #1
0
        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 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));
                }
            }
        }
Beispiel #3
0
        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));
                }
            }
        }
Beispiel #5
0
        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 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));
                }
            }
        }
Beispiel #7
0
        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));
                }
            }
        }
Beispiel #8
0
        public static ControllerContext GetControllerContext(this LiteController ctrl)
        {
            var ad = new ActionDiscoverer(new ParametersDiscoverer(Fakes.FakeServiceProvider.GetServiceProvider(), new Fakes.FakeDefaultLiteApiOptionsRetriever()));
            var controllerDiscoverer = new ControllerDiscoverer(ad, new LiteApiOptionsAccessor(LiteApiOptions.Default));

            var type    = ctrl.GetType();
            var context = new ControllerContext
            {
                ControllerType = type,
                RouteAndName   = GetControllerName(type, controllerDiscoverer)
            };

            context.Actions = ad.GetActions(context);

            return(context);
        }
Beispiel #9
0
        public static ControllerContext GetControllerContext(this LiteController ctrl)
        {
            var ad = new ActionDiscoverer(new ParametersDiscoverer(new Moq.Mock <IServiceProvider>().Object));
            var controllerDiscoverer = new ControllerDiscoverer(ad);

            var type    = ctrl.GetType();
            var context = new ControllerContext
            {
                ControllerType = type,
                RouteAndName   = GetControllerName(type, controllerDiscoverer)
            };

            context.Actions = ad.GetActions(context);

            return(context);
        }
Beispiel #10
0
        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 GetrandomDSUser()
        {
            {
                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 TOP 4 ID_USER,UserName,AVATAR FROM TBL_Account where TINHTRANG=1
        ORDER BY NEWID()", 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_user = r["ID_USER"],
                        hinhanh = r["AVATAR"],
                        Avatar  = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),

                        Username = r["UserName"],
                    };
                    return(JsonResultCommon.ThanhCong(Data));
                }
                catch (Exception ex)
                {
                    return(JsonResultCommon.Exception(ex));
                }
            }
        }
Beispiel #12
0
        public object DataSource_Group(int id_group, [FromQuery] QueryParams query)
        {
            try
            {
                DataRow[] dr;
                PageModel pageModel = new PageModel();
                using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                {
                    string sqlq = @"   
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 ID_GROUP=" + id_group;
                    var    dt   = cnn.CreateDataTable(sqlq);
                    if (cnn.LastError != null || dt == null)
                    {
                        return(JsonResultCommon.SQL(cnn.LastError.Message));
                    }
                    var temp = dt.AsEnumerable();
                    #region Sort/filter
                    Dictionary <string, string> sortableFields = new Dictionary <string, string> {
                        { "UserName", "UserName" },
                    };
                    if (!string.IsNullOrEmpty(query.sortField) && sortableFields.ContainsKey(query.sortField))
                    {
                        if ("asc".Equals(query.sortOrder))
                        {
                            temp = temp.OrderBy(x => x[sortableFields[query.sortField]]);
                        }
                        else
                        {
                            temp = temp.OrderByDescending(x => x[sortableFields[query.sortField]]);
                        }
                    }
                    var xaaaa = query.filter;
                    if (!string.IsNullOrEmpty(query.filter["UserName"]))
                    {
                        string keyword = query.filter["UserName"].ToLower();
                        temp = temp.Where(x => x["UserName"].ToString().ToLower().Contains(keyword));
                    }

                    #endregion
                    int i = temp.Count();
                    if (i == 0)
                    {
                        return(JsonResultCommon.ThanhCong(new List <string>(), pageModel));
                    }
                    dt = temp.CopyToDataTable();

                    int total = dt.Rows.Count;
                    pageModel.TotalCount = total;
                    pageModel.AllPage    = (int)Math.Ceiling(total / (decimal)query.record);
                    pageModel.Size       = query.record;
                    pageModel.Page       = query.page;
                    if (query.more)
                    {
                        query.page   = 1;
                        query.record = pageModel.TotalCount;
                    }


                    // Phân trang
                    dt = dt.AsEnumerable().Skip((query.page - 1) * query.record).Take(query.record).CopyToDataTable();
                    var data = from r in dt.AsEnumerable()
                               //                           where
                               //r["ID_GROUP"].Equals(id_group)
                               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"],
                        hinhanh     = r["AVATAR"],
                        Avatar      = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
                        // Roles = r["roles"],
                    };

                    return(JsonResultCommon.ThanhCong(data, pageModel));
                }
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
Beispiel #13
0
        public BaseModel <object> DS_ThanhVien_Group(int id_group, [FromBody] QueryRequestParams p)
        {
            string    Token     = lc.GetHeader(Request);
            LoginData loginData = lc._GetInfoUser(Token);

            if (loginData == null)
            {
                return(JsonResultCommon.DangNhap());
            }
            try
            {
                using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                {
                    Dictionary <string, string> _sortableFields = new Dictionary <string, string>
                    {
                        { "Username", "Username" },
                        //{ "DonViTinh", "DonViTinh" }
                    };
                    Panigator v_panigator = null;
                    IDictionary <string, string> v_dic_keyFilter = new Dictionary <string, string>
                    {
                        { "Username", "Username" },
                        //{ "DonViTinh", "DonViTinh"},
                    };

                    string        _select = "", _sqlQuery = "", v_str_paginate = "", _orderBy = "", _whereCondition = "";
                    SqlConditions _cond = new SqlConditions();

                    #region Filter, sort, paganitor
                    //filter request have to right and enough , same in code
                    if (p.Filter != null)
                    {
                        if (p.Filter.Count > 0)
                        {
                            var listKeySearch = p.Filter.Where(x => !v_dic_keyFilter.ContainsKey(x.Key)).Select(q => q.Key).ToList();
                            if (listKeySearch != null && listKeySearch.Count > 0)
                            {
                                return(JsonResultCommon.NotData());
                            }

                            foreach (string _filter in p.Filter.Keys)
                            {
                                if (!string.IsNullOrEmpty(p.Filter[_filter]))
                                {
                                    foreach (string vl in p.Filter.Values)
                                    {
                                        //_whereCondition += " AND " + v_dic_keyFilter[_filter] + " = @" + _filter;
                                        _whereCondition += " AND " + v_dic_keyFilter[_filter] + " LIKE'%";
                                        _whereCondition += vl;
                                        _whereCondition += "%'";
                                        _cond.Add(_filter, p.Filter[_filter]);
                                    }
                                }
                            }
                        }
                    }

                    //sort column in datatable
                    if (p.Sort != null)
                    {
                        if (!string.IsNullOrEmpty(p.Sort.ColumnName) && v_dic_keyFilter.ContainsKey(p.Sort.ColumnName))
                        {
                            _orderBy = v_dic_keyFilter[p.Sort.ColumnName] + " " + (p.Sort.Direction.ToLower().Equals("asc") ? "asc" : "desc");
                        }
                    }

                    int page_index = 0;
                    //set up panigator for datatable
                    if (p.Panigator != null)
                    {
                        //v_str_paginate = $@" OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY;";
                        //// offset fetch là các tùy chọn của mệnh đề order by
                        //_cond.Add("PageSize", p.Panigator.PageSize);
                        //_cond.Add("PageNumber", p.Panigator.PageIndex);

                        page_index = p.Panigator.PageIndex;
                    }
                    #endregion

                    _sqlQuery = $@" 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 ID_GROUP=" + id_group + "" + _whereCondition + "";

                    DataTable _datatable = cnn.CreateDataTable(_sqlQuery, _cond);
                    int       _countRows = _datatable.Rows.Count;
                    if (cnn.LastError != null || _datatable == null)
                    {
                        return(JsonResultCommon.NotData());
                    }

                    if (_datatable.Rows.Count == 0)
                    {
                        return(JsonResultCommon.NotData());
                    }
                    else
                    {
                        if (page_index == 0)
                        {
                            p.Panigator.PageSize = _countRows;
                        }
                        v_panigator = new Panigator(p.Panigator.PageIndex, p.Panigator.PageSize, _datatable.Rows.Count);
                    }

                    var _data = from r in _datatable.AsEnumerable().Skip((p.Panigator.PageIndex - 1) * p.Panigator.PageSize).Take(p.Panigator.PageSize).ToList()
                                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"],
                        hinhanh     = r["AVATAR"],
                        Avatar      = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
                    };

                    return(JsonResultCommon.ThanhCong(_data, v_panigator));
                }
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
Beispiel #14
0
        public object getDSUser_Group(int id_group)
        {
            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
            {
                //Conds.Add("email", Email);
                //Conds.Add("password", Pass);
                using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                {
                    dt_group = cnn.CreateDataTable(@"  select * from TBL_GROUP as g, TBL_GROUPMEMBER as u where g.ID_GROUP=u.ID_GROUP");

                    dt = cnn.CreateDataTable(@"
select  gu.ID_GROUP,g.TEN_GROUP,u.ID_USER,QUYEN_ADMIN,gu.CREATE_DATE as
 ngaythamgia,UserName,AVATAR,TINHTRANG from TBL_GROUPMEMBER as gu,TBL_Account as u ,
  TBL_GROUP as g where gu.ID_USER=u.ID_USER and gu.ID_GROUP=g.ID_GROUP

", Conds);


                    //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
                }



                var data = from g in dt_group.AsEnumerable()
                           where g["ID_GROUP"].Equals(id_group) && g["ID_USER"].ToString() == loginData.Id.ToString()
                           select new
                {
                    ID_group  = g["ID_GROUP"],
                    Ten_Group = g["TEN_GROUP"],
                    id_user   = g["ID_USER"],
                    //id_user = r["ID_USER"],

                    //user_name = r["UserName"],
                    quyen_group = g["QUYEN_ADMIN"],
                    //Create_date = r["ngaythamgia"],
                    //tinhtrang = r["TINHTRANG"],


                    //avatar_user = r["AVATAR"]
                    //Icon_app = r["ICON_APP"],



                    Group_member = from r in dt.AsEnumerable()
                                   where r["ID_GROUP"].Equals(g["ID_GROUP"])
                                   select new
                    {
                        id_user = r["ID_USER"],

                        user_name = r["UserName"],

                        Create_date = r["ngaythamgia"],
                        tinhtrang   = r["TINHTRANG"],
                        hinhanh     = r["AVATAR"],

                        avatar_user = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
                        //Icon_app = r["ICON_APP"],
                    },
                };
                return(JsonResultCommon.ThanhCong(data));
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
Beispiel #15
0
        /// <summary>
        /// Invokes the specified <see cref="ActionContext"/>.
        /// </summary>
        /// <param name="httpCtx">The HTTP context, set by the middleware.</param>
        /// <param name="actionCtx">The action context.</param>
        /// <param name="logger">Logger to use, can be null</param>
        /// <returns></returns>
        public virtual async Task Invoke(HttpContext httpCtx, ActionContext actionCtx, ILogger logger = null)
        {
            logger?.LogInformation("Checking filters");
            ApiFilterRunResult filterResult = await RunFiltersAndCheckIfShouldContinue(httpCtx, actionCtx);

            logger?.LogInformation($"Checking filters completed, can invoke: {filterResult.ShouldContinue}");

            if (!filterResult.ShouldContinue)
            {
                int failedStatusCode = 0;
                if (filterResult.SetResponseCode.HasValue)
                {
                    failedStatusCode = filterResult.SetResponseCode.Value;
                }
                else
                {
                    bool isAuthenticated = httpCtx?.User?.Identity?.IsAuthenticated ?? false;
                    if (isAuthenticated)
                    {
                        failedStatusCode = 403;
                    }
                    else
                    {
                        failedStatusCode = 401;
                    }
                }
                httpCtx.Response.StatusCode = failedStatusCode;
                await httpCtx.Response.WriteAsync(filterResult.SetResponseMessage ?? "request rejected");

                logger?.LogInformation($"returning response with status code: {failedStatusCode}");
                return;
            }

            logger?.LogInformation($"Building controller: {actionCtx.ParentController}");
            LiteController ctrl = _controllerBuilder.Build(actionCtx.ParentController, httpCtx);

            object[] paramValues = _modelBinder.GetParameterValues(httpCtx.Request, actionCtx);
            logger?.LogInformation($"Building controller succeeded: {actionCtx.ParentController}");
            logger?.LogInformation($"Invoking action: {actionCtx}");
            object result = null;
            bool   isVoid = true;

            if (actionCtx.Method.ReturnType == typeof(void))
            {
                actionCtx.Method.Invoke(ctrl, paramValues);
            }
            else if (actionCtx.Method.ReturnType == typeof(Task))
            {
                var   task = (actionCtx.Method.Invoke(ctrl, paramValues) as Task);
                await task;
            }
            else if (actionCtx.Method.ReturnType.IsConstructedGenericType && actionCtx.Method.ReturnType.GetGenericTypeDefinition() == typeof(Task <>))
            {
                isVoid = false;
                var task = (dynamic)(actionCtx.Method.Invoke(ctrl, paramValues));
                result = await task;
            }
            else
            {
                isVoid = false;
                result = actionCtx.Method.Invoke(ctrl, paramValues);
            }

            int?overridenResponseCode = httpCtx.GetResponseStatusCode();

            if (overridenResponseCode.HasValue)
            {
                httpCtx.Response.StatusCode = overridenResponseCode.Value;
            }
            else
            {
                int statusCode = 405; // method not allowed
                switch (httpCtx.Request.Method.ToUpper())
                {
                case "GET": statusCode = 200; break;

                case "POST": statusCode = 201; break;

                case "PUT": statusCode = 201; break;

                case "DELETE": statusCode = 204; break;
                }
                httpCtx.Response.StatusCode = statusCode;
            }

            httpCtx.Response.Headers.Add("X-Powered-By-Middleware", "LiteApi");
            var additionalHeaders = httpCtx.GetResponseHeaders(true);

            if (additionalHeaders != null)
            {
                foreach (var header in additionalHeaders)
                {
                    httpCtx.Response.Headers.Add(header.Key, header.Value);
                }
            }

            if (isVoid)
            {
                logger?.LogInformation("Not serializing result from invoked action, action is void or void task");
            }
            else
            {
                logger?.LogInformation("Serializing result from invoked action");
                if (actionCtx.IsReturningLiteActionResult)
                {
                    await(result as ILiteActionResult).WriteResponse(httpCtx, actionCtx);
                }
                else
                {
                    httpCtx.Response.ContentType = "application/json";
                    await httpCtx.Response.WriteAsync(_jsonSerializer.Serialize(result));
                }
            }
        }
Beispiel #16
0
 public static ControllerContext[] GetControllerContextAsArray(this LiteController ctrl)
 {
     return(new ControllerContext[] { ctrl.GetControllerContext() });
 }
        public object getDSBaiDangViewDetail(int id_baidang)
        {
            string    Token     = lc.GetHeader(Request);
            LoginData loginData = lc._GetInfoUser(Token);

            if (loginData == null)
            {
                return(JsonResultCommon.DangNhap());
            }
            PageModel     pageModel = new PageModel();
            string        sql       = "";
            SqlConditions Conds     = new SqlConditions();
            DataTable     dt_group  = new DataTable();

            DataTable dt_baidang = new DataTable();
            DataTable dt_user    = new DataTable();

            DataTable dt_like_baidang = new DataTable();

            DataTable dt_like_comment = new DataTable();
            DataTable dt_comment      = new DataTable();
            DataTable dt_user_comment = new DataTable();
            DataTable dt                = new DataTable();
            DataTable dt_like           = new DataTable();
            DataTable dt_comment_parent = new DataTable();
            DataTable dt_icon           = new DataTable();

            DataTable dt_baidang_like_user = new DataTable();

            DataTable dt_comment_like_user = new DataTable();

            DataTable dt_kt = new DataTable();

            DataRow[] dr;
            // DataRow[] dr;


            try
            {
                ////tesst tam
                //sql = @"select* from TBL_BAIDANG";

                // code dung
                sql = @"
                select ID_BAIDANG,ID_LOAIBAIDANG,TIEUDE,NOIDUNG_BAIDANG,TYPEPOST,CreatedDate,CreatedBy,UpdateDate,UpdateBy,ID_KHENTHUONG,ID_GROUP from TBL_BAIDANG
                ORDER BY ID_BAIDANG DESC";


                using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                {
                    dt         = cnn.CreateDataTable(sql, Conds);
                    dt_comment = cnn.CreateDataTable(@"select * from TBL_COMMENT");
                    dt_like    = cnn.CreateDataTable(@"select * from TBL_COMMENT");
                    //dt_user_baidang = cnn.CreateDataTable(@"select * from TBL_USER");
                    dt_user = cnn.CreateDataTable(@"select * from TBL_Account");

                    dt_like_baidang = cnn.CreateDataTable(@" 
   select l.ID_LIKE,likebd.ID_BAIDANG, l.title,count(likebd.ID_LIKE) as tong ,l.LINK_ICON from TBL_BAIDANG_LIKE as likebd ,TBL_LIKE as l where
 l.ID_LIKE=likebd.ID_LIKE and likebd.COL_DISABLED=0  group by l.title,likebd.ID_BAIDANG,l.ID_LIKE,l.LINK_ICON
");
                    dt_user_comment = cnn.CreateDataTable(@"select * from TBL_Account");
                    dt_like_comment = cnn.CreateDataTable(@"     select l.ID_LIKE,cmtlike.ID_COMMENT, l.title,count(cmtlike.ID_LIKE) as tong,l.LINK_ICON  from TBL_COMMENT_LIKE as cmtlike ,TBL_LIKE as l where
 l.ID_LIKE=cmtlike.ID_LIKE and cmtlike.COL_DISABLED=0 group by l.title,cmtlike.ID_COMMENT,l.ID_LIKE,l.LINK_ICON   

");

                    dt_icon = cnn.CreateDataTable("select * from TBL_LIKE");

                    dt_baidang_like_user = cnn.CreateDataTable(@" select l.ID_LIKE,likebd.ID_BAIDANG, l.title,l.LINK_ICON,likebd.CREATE_BY,likebd.COL_DISABLED from TBL_BAIDANG_LIKE as likebd ,TBL_LIKE as l where
 l.ID_LIKE=likebd.ID_LIKE and likebd.COL_DISABLED=0
  
");

                    dt_comment_like_user = cnn.CreateDataTable(@" select l.ID_LIKE,like_cmt.ID_COMMENT, l.title,l.LINK_ICON,like_cmt.CREATE_BY  from TBL_COMMENT_LIKE as like_cmt ,TBL_LIKE as l where
 l.ID_LIKE=like_cmt.ID_LIKE and like_cmt.COL_DISABLED=0
");

                    dt_comment_parent = cnn.CreateDataTable(@"  SELECT *
FROM TBL_COMMENT
WHERE ID_COMMENT_PARENT !=0");
                    dt_kt             = cnn.CreateDataTable(@"

select * from TBL_KHENTHUONG
");
                    dt_group          = cnn.CreateDataTable(@"

select ID_GROUP,TEN_GROUP from TBL_GROUP 
");
                }


                var total = dt.Rows.Count;
                if (total == 0)
                {
                    return(JsonResultCommon.ThanhCong(string.Empty, pageModel));
                }



                //  status = 1,
                var data = from r in dt.AsEnumerable()
                           where r["ID_BAIDANG"].Equals(id_baidang)
                           select new
                {
                    Id_BaiDang     = r["ID_BAIDANG"],
                    Id_LoaiBaiDang = r["ID_LOAIBAIDANG"],
                    title          = r["TIEUDE"],
                    NoiDung        = r["NOIDUNG_BAIDANG"],
                    CreatedDate    = r["CreatedDate"],
                    CreatedBy      = r["CreatedBy"],
                    hinhanh        = r["TYPEPOST"],
                    image          = LiteController.genLinkImage_Post(_config.LinkAPI, r["TYPEPOST"]),
                    //Id_Group = r["ID_GROUP"],
                    UpdateDate    = r["UpdateDate"],
                    UpdateBy      = r["UpdateBy"],
                    id_khenthuong = r["ID_KHENTHUONG"],
                    AllowEdit     = r["CreatedBy"],

                    Group = from g in dt_group.AsEnumerable()
                            where r["ID_GROUP"].Equals(g["ID_GROUP"])
                            select new
                    {
                        id_group  = g["ID_GROUP"],
                        ten_group = g["TEN_GROUP"],
                        //icon = g["LINK_ICON"],
                    },

                    // bai dang duoc like

                    KhenThuong = from kt in dt_kt.AsEnumerable()
                                 where r["ID_KHENTHUONG"].Equals(kt["ID_KHENTHUONG"])
                                 select new
                    {
                        id_khenthuong = kt["ID_KHENTHUONG"],
                        tieude_kt     = kt["TIEUDE"],
                        icon          = kt["LINK_ICON"],
                    },


                    Like = (
                        from lr in dt_baidang_like_user.AsEnumerable()
                        where lr["ID_BAIDANG"].Equals(r["ID_BAIDANG"]) && lr["CREATE_BY"].Equals(loginData.Id)
                        //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                        select new
                    {
                        CreateBy = lr["CREATE_BY"],
                        ID_like = lr["ID_LIKE"],
                        title = lr["title"],
                        icon = lr["LINK_ICON"],
                        //icon_app = lr["ICON_APP"]
                    }).FirstOrDefault(),

                    //Like = ttt,
                    Like_BaiDang = from like_bd in dt_like_baidang.AsEnumerable()
                                   where like_bd["ID_BAIDANG"].ToString().Equals(r["ID_BAIDANG"].ToString())
                                   select new
                    {
                        ID_like = like_bd["ID_LIKE"],
                        title   = like_bd["title"],
                        icon    = like_bd["LINK_ICON"],
                        //icon_app= like_bd["ICON_APP"],
                        tong = like_bd["tong"],
                    },
                    User_DangBai = from user in dt_user.AsEnumerable()
                                   where user["ID_USER"].ToString().Equals(r["CreatedBy"].ToString())
                                   select new
                    {
                        ID_user  = user["ID_USER"],
                        Username = user["UserName"],
                        ID_NV    = user["IDNV"],
                        hinhanh  = user["AVATAR"],
                        avatar   = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                    },
                    // Trong bai dang co nhung commet nao
                    Coment = from h in dt_comment.AsEnumerable()
                             where h["ID_BAIDANG"].ToString().Equals(r["ID_BAIDANG"].ToString())
                             select new
                    {
                        id_cmt     = h["ID_COMMENT"],
                        Id_BaiDang = h["ID_BAIDANG"],

                        NoiDung_cmt   = h["NOIDUNG_COMMENT"],
                        typepost      = h["TYPEPOST"],
                        CreatedBy     = h["CreatedBy_cmt"],
                        CreatedDate   = h["CreatedDate_cmt"],
                        id_cmt_parent = h["ID_COMMENT_PARENT"],
                        //Dan_Nhan = h["ID_DANNHAN"],
                        UpdatedDate = h["UpdatedDate_cmt"],
                        UpdatedBy   = h["UpdatedBy_cmt"],
                        AllowEdit   = h["CreatedBy_cmt"],

                        User_comment = from user in dt_user.AsEnumerable()
                                       where user["ID_USER"].ToString().Equals(h["CreatedBy_cmt"].ToString())
                                       select new
                        {
                            ID_user  = user["ID_USER"],
                            Username = user["UserName"],
                            ID_NV    = user["IDNV"],
                            hinhanh  = user["AVATAR"],
                            avatar   = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                        },
                        Like = (
                            from lr in dt_comment_like_user.AsEnumerable()
                            where lr["ID_COMMENT"].Equals(h["ID_COMMENT"]) && lr["CREATE_BY"].Equals(loginData.Id)
                            //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                            select new
                        {
                            CreateBy = lr["CREATE_BY"],
                            ID_like = lr["ID_LIKE"],
                            title = lr["title"],
                            icon = lr["LINK_ICON"],
                            //icon_app = lr["ICON_APP"],
                        }).FirstOrDefault(),
                        Like_Comment = from like_cmt in dt_like_comment.AsEnumerable()
                                       where like_cmt["ID_COMMENT"].ToString().Equals(h["ID_COMMENT"].ToString())
                                       select new
                        {
                            ID_like = like_cmt["ID_LIKE"],
                            title   = like_cmt["title"],
                            icon    = like_cmt["LINK_ICON"],
                            //icon_app = like_cmt["ICON_APP"],
                            tong = like_cmt["tong"],
                        },

                        Comment_child = from like_cmt_chill in dt_comment_parent.AsEnumerable()
                                        where like_cmt_chill["ID_COMMENT_PARENT"].ToString().Equals(h["ID_COMMENT"].ToString())
                                        select new
                        {
                            id_cmt     = like_cmt_chill["ID_COMMENT"],
                            Id_BaiDang = like_cmt_chill["ID_BAIDANG"],

                            NoiDung_cmt     = like_cmt_chill["NOIDUNG_COMMENT"],
                            TypePost        = like_cmt_chill["TYPEPOST"],
                            CreatedBy_cmt   = like_cmt_chill["CreatedBy_cmt"],
                            CreatedDate_cmt = like_cmt_chill["CreatedDate_cmt"],
                            id_cmt_parent   = like_cmt_chill["ID_COMMENT_PARENT"],
                            //Dan_Nhan = h["ID_DANNHAN"],
                            UpdatedDate_cmt = like_cmt_chill["UpdatedDate_cmt"],
                            UpdatedBy_cmt   = like_cmt_chill["UpdatedBy_cmt"],
                            AllowEdit       = like_cmt_chill["CreatedBy_cmt"],

                            User_comment_child = from user in dt_user.AsEnumerable()
                                                 where user["ID_USER"].ToString().Equals(like_cmt_chill["CreatedBy_cmt"].ToString())
                                                 select new
                            {
                                ID_user  = user["ID_USER"],
                                Username = user["UserName"],
                                ID_NV    = user["IDNV"],
                                hinhanh  = user["AVATAR"],
                                avatar   = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                            },

                            Like_child = (
                                from lr in dt_comment_like_user.AsEnumerable()
                                where lr["ID_COMMENT"].Equals(like_cmt_chill["ID_COMMENT"]) && lr["CREATE_BY"].Equals(loginData.Id)
                                //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                                select new
                            {
                                CreateBy = lr["CREATE_BY"],
                                ID_like = lr["ID_LIKE"],
                                title = lr["title"],
                                icon = lr["LINK_ICON"],
                                //icon_app = lr["ICON_APP"],
                            }).FirstOrDefault(),
                            Like_Comment_child = from like_cmt in dt_like_comment.AsEnumerable()
                                                 where like_cmt["ID_COMMENT"].ToString().Equals(like_cmt_chill["ID_COMMENT"].ToString())
                                                 select new
                            {
                                ID_like = like_cmt["ID_LIKE"],
                                title   = like_cmt["title"],
                                icon    = like_cmt["LINK_ICON"],
                                //icon_app = like_cmt["ICON_APP"],
                                tong = like_cmt["tong"],
                            },
                        },
                    },
                };



                //CustemerID = loginData.IDKHDPS,
                return(JsonResultCommon.ThanhCong(data, pageModel));
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
Beispiel #18
0
        public object GetDataEDit(int id_baidang)
        {
            {
                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_kt    = new DataTable();
                DataTable     dt_token = new DataTable();
                try
                {
                    //Conds.Add("email", Email);
                    //Conds.Add("password", Pass);
                    using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                    {
                        dt_kt = cnn.CreateDataTable(@"

select * from TBL_KHENTHUONG
");

                        dt = cnn.CreateDataTable(@"

   select * from TBL_BAIDANG where ID_BAIDANG=" + id_baidang, 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_BaiDang     = r["ID_BAIDANG"],
                        Id_LoaiBaiDang = r["ID_LOAIBAIDANG"],
                        title          = r["TIEUDE"],
                        NoiDung        = r["NOIDUNG_BAIDANG"],
                        CreatedDate    = r["CreatedDate"],
                        CreatedBy      = r["CreatedBy"],
                        Id_Group       = r["ID_GROUP"],
                        hinhanh        = r["TYPEPOST"],
                        image          = LiteController.genLinkImage_Post(_config.LinkAPI, r["TYPEPOST"]),
                        UpdateDate     = r["UpdateDate"],
                        UpdateBy       = r["UpdateBy"],
                        id_khenthuong  = r["ID_KHENTHUONG"],
                        AllowEdit      = r["CreatedBy"],

                        KhenThuong = from kt in dt_kt.AsEnumerable()
                                     where r["ID_KHENTHUONG"].Equals(kt["ID_KHENTHUONG"])
                                     select new
                        {
                            id_khenthuong = kt["ID_KHENTHUONG"],
                            tieude_kt     = kt["TIEUDE"],
                            icon          = kt["LINK_ICON"],
                        },
                    };
                    return(JsonResultCommon.ThanhCong(data));
                }
                catch (Exception ex)
                {
                    return(JsonResultCommon.Exception(ex));
                }
            }
        }
Beispiel #19
0
        public object getFlow(int id_canhan)
        {
            int           status    = 0;
            string        Id        = "";
            string        Token     = "";
            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))
                {
                    dt_user = cnn.CreateDataTable(@"select  top 4 USER_Flow from TBL_Flow where ID_CANHAN=" + id_canhan + "ORDER by newid()", Conds);


                    dt       = cnn.CreateDataTable(@" select ID_USER,AVATAR,TINHTRANG from TBL_Account ");
                    dt_count = cnn.CreateDataTable(@"select count(ID_CANHAN) as tong,ID_CANHAN from TBL_Flow where ID_CANHAN=" + id_canhan + "group by ID_CANHAN");
                }


                var data = from g in dt_count.AsEnumerable()

                           select new
                {
                    tong = g["tong"],

                    Flow = from cnt in dt_user.AsEnumerable()

                           select new
                    {
                        user_flow = cnt["USER_Flow"],


                        TT_User_Flow = from flow in dt.AsEnumerable()
                                       where flow["ID_USER"].Equals(cnt["USER_Flow"])
                                       select new
                        {
                            TinhTrang = flow["TINHTRANG"],
                            hinh      = flow["AVATAR"],

                            Avatar = LiteController.genLinkAvatar(_config.LinkAPI, flow["AVATAR"]),
                        },
                    },
                };



                return(JsonResultCommon.ThanhCong(data));
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
Beispiel #20
0
        public object getDSBaiDangFlowTrangCaNhan(int id, [FromQuery] QueryParams_New query)

        {
            //string Token = lc.GetHeader(Request);
            //LoginData loginData = lc._GetInfoUser(Token);
            //if (loginData == null)
            //    return JsonResultCommon.DangNhap();

            PageModel     pageModel   = new PageModel();
            string        sql         = "";
            string        sql_baidang = "";
            SqlConditions Conds       = new SqlConditions();


            DataTable dt_baidang = new DataTable();
            DataTable dt_user    = new DataTable();

            DataTable dt_like_baidang = new DataTable();

            DataTable dt_like_comment = new DataTable();
            DataTable dt_comment      = new DataTable();
            DataTable dt_user_comment = new DataTable();
            DataTable dt                = new DataTable();
            DataTable dt_like           = new DataTable();
            DataTable dt_comment_parent = new DataTable();
            DataTable dt_icon           = new DataTable();

            DataTable dt_baidang_like_user = new DataTable();

            DataTable dt_comment_like_user = new DataTable();
            DataTable dt_baidangcanhan     = new DataTable();
            DataTable dt_kt    = new DataTable();
            DataTable dt_group = new DataTable();

            DataRow[] dr;
            // DataRow[] dr;



            try
            {
                sql_baidang = @" select ID_BAIDANG,CreatedDate from TBL_BAIDANG where CreatedBy=" + id + "UNION select ID_BAIDANG,CreatedDate from TBL_BaiDang_TRANGCANHAN where ID_USER="******" ORDER BY CreatedDate DESC";

                sql = @"
  select ID_BAIDANG,ID_LOAIBAIDANG,TIEUDE,NOIDUNG_BAIDANG,TYPEPOST,CreatedDate,CreatedBy,UpdateDate,UpdateBy,ID_KHENTHUONG,ID_GROUP from TBL_BAIDANG
                ORDER BY ID_BAIDANG DESC";


                using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
                {
                    //dt = cnn.CreateDataTable(sql, Conds);

                    dt_baidangcanhan = cnn.CreateDataTable(sql_baidang, Conds);
                    Thread.Sleep(500);
                    dt         = cnn.CreateDataTable(sql);
                    dt_comment = cnn.CreateDataTable(@"select * from TBL_COMMENT");
                    dt_like    = cnn.CreateDataTable(@"select * from TBL_COMMENT");
                    //dt_user_baidang = cnn.CreateDataTable(@"select * from TBL_USER");
                    dt_user = cnn.CreateDataTable(@"select * from TBL_Account");

                    dt_like_baidang = cnn.CreateDataTable(@" 
   select l.ID_LIKE,likebd.ID_BAIDANG, l.title,count(likebd.ID_LIKE) as tong ,l.LINK_ICON from TBL_BAIDANG_LIKE as likebd ,TBL_LIKE as l where
 l.ID_LIKE=likebd.ID_LIKE and likebd.COL_DISABLED=0  group by l.title,likebd.ID_BAIDANG,l.ID_LIKE,l.LINK_ICON
");
                    dt_user_comment = cnn.CreateDataTable(@"select * from TBL_Account");
                    dt_like_comment = cnn.CreateDataTable(@" select top 3 l.ID_LIKE,cmtlike.ID_COMMENT, l.title,count(cmtlike.ID_LIKE) as tong,l.LINK_ICON  from TBL_COMMENT_LIKE as cmtlike ,TBL_LIKE as l where
 l.ID_LIKE=cmtlike.ID_LIKE and cmtlike.COL_DISABLED=0
 group by l.title,cmtlike.ID_COMMENT,l.ID_LIKE,l.LINK_ICON order by tong desc   
");

                    dt_icon = cnn.CreateDataTable("select * from TBL_LIKE");

                    dt_baidang_like_user = cnn.CreateDataTable(@" select l.ID_LIKE,likebd.ID_BAIDANG, l.title,l.LINK_ICON,likebd.CREATE_BY,likebd.COL_DISABLED from TBL_BAIDANG_LIKE as likebd ,TBL_LIKE as l where
 l.ID_LIKE=likebd.ID_LIKE and likebd.COL_DISABLED=0
  
");

                    dt_comment_like_user = cnn.CreateDataTable(@" select l.ID_LIKE,like_cmt.ID_COMMENT, l.title,l.LINK_ICON,like_cmt.CREATE_BY  from TBL_COMMENT_LIKE as like_cmt ,TBL_LIKE as l where
 l.ID_LIKE=like_cmt.ID_LIKE and like_cmt.COL_DISABLED=0
");

                    dt_comment_parent = cnn.CreateDataTable(@"  SELECT *
FROM TBL_COMMENT
WHERE ID_COMMENT_PARENT !=0");
                    dt_kt             = cnn.CreateDataTable(@"

select * from TBL_KHENTHUONG
");

                    dt_group = cnn.CreateDataTable(@"

select ID_GROUP,TEN_GROUP from TBL_GROUP 
");
                }


                int total = dt_baidangcanhan.Rows.Count;


                pageModel.TotalCount = total;
                pageModel.AllPage    = (int)Math.Ceiling(total / (decimal)query.record);
                pageModel.Size       = query.record;
                pageModel.Page       = query.page;
                if (query.more)
                {
                    query.page   = 1;
                    query.record = pageModel.TotalCount;
                }
                if (query.page <= pageModel.AllPage)
                {
                    dt_baidangcanhan = dt_baidangcanhan.AsEnumerable().Skip((query.page - 1) * query.record).Take(query.record).CopyToDataTable();
                }
                else
                {
                    return(JsonResultCommon.NotData());
                }


                //lay anh usser


                //anh usser cmt



                var data = from p in dt_baidangcanhan.AsEnumerable()
                           select new
                {
                    Id_baidang_canhan = p["ID_BAIDANG"],


                    DataBaiDang = from r in dt.AsEnumerable()
                                  where r["ID_BAIDANG"].ToString().Equals(p["ID_BAIDANG"].ToString())
                                  select new
                    {
                        Id_BaiDang     = r["ID_BAIDANG"],
                        Id_LoaiBaiDang = r["ID_LOAIBAIDANG"],
                        title          = r["TIEUDE"],
                        NoiDung        = r["NOIDUNG_BAIDANG"],
                        CreatedDate    = r["CreatedDate"],
                        CreatedBy      = r["CreatedBy"],
                        // Id_Group = r["ID_GROUP"],
                        hinhanh = r["TYPEPOST"],
                        image   = LiteController.genLinkImage_Post(_config.LinkAPI, r["TYPEPOST"]),
                        //UpdateDate = r["UpdateDate"],
                        //UpdateBy = r["UpdateBy"],
                        ///   id_khenthuong = r["ID_KHENTHUONG"]



                        AllowEdit = r["CreatedBy"],

                        // bai dang duoc like
                        Group = from g in dt_group.AsEnumerable()
                                where r["ID_GROUP"].Equals(g["ID_GROUP"])
                                select new
                        {
                            id_group  = g["ID_GROUP"],
                            ten_group = g["TEN_GROUP"],
                            //icon = g["LINK_ICON"],
                        },


                        KhenThuong = from kt in dt_kt.AsEnumerable()
                                     where r["ID_KHENTHUONG"].Equals(kt["ID_KHENTHUONG"])
                                     select new
                        {
                            id_khenthuong = kt["ID_KHENTHUONG"],
                            tieude_kt     = kt["TIEUDE"],
                            icon          = kt["LINK_ICON"],
                        },


                        Like = dt_baidang_like_user == null ? null : (

                            from lr in dt_baidang_like_user.AsEnumerable()
                            where lr["ID_BAIDANG"].Equals(r["ID_BAIDANG"]) && lr["CREATE_BY"].Equals(id)
                            //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                            select new
                        {
                            CreateBy = lr["CREATE_BY"],
                            ID_like = lr["ID_LIKE"],
                            title = lr["title"],
                            icon = lr["LINK_ICON"],
                            //icon_app = lr["ICON_APP"]
                        }).FirstOrDefault(),

                        //Like = ttt,
                        Like_BaiDang = from like_bd in dt_like_baidang.AsEnumerable()
                                       where like_bd["ID_BAIDANG"].ToString().Equals(r["ID_BAIDANG"].ToString())
                                       select new
                        {
                            ID_like = like_bd["ID_LIKE"],
                            title   = like_bd["title"],
                            icon    = like_bd["LINK_ICON"],
                            //icon_app= like_bd["ICON_APP"],
                            tong = like_bd["tong"],
                        },
                        User_DangBai = from user in dt_user.AsEnumerable()
                                       where user["ID_USER"].ToString().Equals(r["CreatedBy"].ToString())
                                       select new
                        {
                            ID_user  = user["ID_USER"],
                            Username = user["UserName"],
                            ID_NV    = user["IDNV"],

                            hinhanh = user["AVATAR"],
                            avatar  = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                        },
                        // Trong bai dang co nhung commet nao
                        Coment = from h in dt_comment.AsEnumerable()
                                 where h["ID_BAIDANG"].ToString().Equals(r["ID_BAIDANG"].ToString())
                                 select new
                        {
                            id_cmt     = h["ID_COMMENT"],
                            Id_BaiDang = h["ID_BAIDANG"],

                            NoiDung_cmt = h["NOIDUNG_COMMENT"],
                            typepost    = h["TYPEPOST"],
                            //  hinh_cmt = $"{link}/UploadedFiles/{h["TYPEPOST"]}",
                            CreatedBy     = h["CreatedBy_cmt"],
                            CreatedDate   = h["CreatedDate_cmt"],
                            id_cmt_parent = h["ID_COMMENT_PARENT"],
                            //Dan_Nhan = h["ID_DANNHAN"],
                            //UpdatedDate = h["UpdatedDate_cmt"],
                            //UpdatedBy = h["UpdatedBy_cmt"],
                            AllowEdit = h["CreatedBy_cmt"],

                            User_comment = from user in dt_user.AsEnumerable()
                                           where user["ID_USER"].ToString().Equals(h["CreatedBy_cmt"].ToString())
                                           select new
                            {
                                ID_user  = user["ID_USER"],
                                Username = user["UserName"],
                                ID_NV    = user["IDNV"],
                                hinhanh  = user["AVATAR"],
                                avatar   = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                            },
                            Like = (
                                from lr in dt_comment_like_user.AsEnumerable()
                                where lr["ID_COMMENT"].Equals(h["ID_COMMENT"]) && lr["CREATE_BY"].Equals(id
                                                                                                         )
                                //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                                select new
                            {
                                CreateBy = lr["CREATE_BY"],
                                ID_like = lr["ID_LIKE"],
                                title = lr["title"],
                                icon = lr["LINK_ICON"],
                                //icon_app = lr["ICON_APP"],
                            }).FirstOrDefault(),
                            Like_Comment = from like_cmt in dt_like_comment.AsEnumerable()
                                           where like_cmt["ID_COMMENT"].ToString().Equals(h["ID_COMMENT"].ToString())
                                           select new
                            {
                                ID_like = like_cmt["ID_LIKE"],
                                title   = like_cmt["title"],
                                icon    = like_cmt["LINK_ICON"],
                                //icon_app = like_cmt["ICON_APP"],
                                tong = like_cmt["tong"],
                            },

                            Comment_child = from like_cmt_chill in dt_comment_parent.AsEnumerable()
                                            where like_cmt_chill["ID_COMMENT_PARENT"].ToString().Equals(h["ID_COMMENT"].ToString())
                                            select new
                            {
                                id_cmt = like_cmt_chill["ID_COMMENT"],
                                //Id_BaiDang = like_cmt_chill["ID_BAIDANG"],

                                NoiDung_cmt = like_cmt_chill["NOIDUNG_COMMENT"],
                                TypePost    = like_cmt_chill["TYPEPOST"],
                                //  hinh_cmt = $"{link}/UploadedFiles/{like_cmt_chill["TYPEPOST"]}",
                                CreatedBy     = like_cmt_chill["CreatedBy_cmt"],
                                CreatedDate   = like_cmt_chill["CreatedDate_cmt"],
                                id_cmt_parent = like_cmt_chill["ID_COMMENT_PARENT"],
                                //Dan_Nhan = h["ID_DANNHAN"],
                                //UpdatedDate_cmt = like_cmt_chill["UpdatedDate_cmt"],
                                //UpdatedBy_cmt = like_cmt_chill["UpdatedBy_cmt"],
                                AllowEdit = like_cmt_chill["CreatedBy_cmt"],

                                User_comment_child = from user in dt_user.AsEnumerable()
                                                     where user["ID_USER"].ToString().Equals(like_cmt_chill["CreatedBy_cmt"].ToString())
                                                     select new
                                {
                                    ID_user  = user["ID_USER"],
                                    Username = user["UserName"],
                                    ID_NV    = user["IDNV"],
                                    hinhanh  = user["AVATAR"],
                                    avatar   = LiteController.genLinkAvatar(_config.LinkAPI, user["AVATAR"]),
                                },

                                Like_child = (
                                    from lr in dt_comment_like_user.AsEnumerable()
                                    where lr["ID_COMMENT"].Equals(like_cmt_chill["ID_COMMENT"]) && lr["CREATE_BY"].Equals(id
                                                                                                                          )
                                    //&& lr["CreatedBy"].Equals(r["CreatedBy"]))
                                    select new
                                {
                                    CreateBy = lr["CREATE_BY"],
                                    ID_like = lr["ID_LIKE"],
                                    title = lr["title"],
                                    icon = lr["LINK_ICON"],
                                    //icon_app = lr["ICON_APP"],
                                }).FirstOrDefault(),
                                Like_Comment_child = from like_cmt in dt_like_comment.AsEnumerable()
                                                     where like_cmt["ID_COMMENT"].ToString().Equals(like_cmt_chill["ID_COMMENT"].ToString())
                                                     select new
                                {
                                    ID_like = like_cmt["ID_LIKE"],
                                    title   = like_cmt["title"],
                                    icon    = like_cmt["LINK_ICON"],
                                },
                            },
                        },
                    },
                };



                //CustemerID = loginData.IDKHDPS,
                //  page = pageModel;
                return(JsonResultCommon.ThanhCong(data, pageModel));

                // ; ; ;
            }
            catch (Exception ex)
            {
                return(JsonResultCommon.Exception(ex));
            }
        }
        /// <summary>
        /// Tìm người dùng
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public LoginData FindAsync(string userName, string password)
        {
            DataTable Tb = null;

            using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
            {
                string sqlq = @"select ID_USER,nv.IDNV,UserName,AVATAR,TINHTRANG,nv.CHUCVU
 from TBL_Account as ac,TBL_NHANVIEN as nv where Email='" + userName + "' and Pass='******'  and ac.IDNV=nv.IDNV";
                Tb = Conn.CreateDataTable(sqlq);
                if (Tb == null || Tb.Rows.Count != 1)
                {
                    return(null);
                }
                var rw = Tb.Rows[0];
                //string hash = rw["Pass"].ToString();
                //string pass = DpsLibs.Common.EncDec.Decrypt(hash, PASSWORD_ED);
                //if (password.Equals(pass))
                {
                    LoginData _Dpsuser = new LoginData();

                    _Dpsuser.ID_user = int.Parse(rw["ID_USER"].ToString());

                    _Dpsuser.Id        = int.Parse(rw["ID_USER"].ToString());
                    _Dpsuser.Id_nv     = int.Parse(rw["IDNV"].ToString());
                    _Dpsuser.UserName  = rw["UserName"].ToString();
                    _Dpsuser.Avatar    = LiteController.genLinkAvatar(_config.LinkAPI, rw["AVATAR"]);
                    _Dpsuser.TinhTrang = bool.Parse(rw["TINHTRANG"].ToString());
                    _Dpsuser.chucvu    = rw["CHUCVU"].ToString();
                    //_Dpsuser.FullName = rw["FullName"].ToString();
                    //_Dpsuser.ChucVu = rw["IdChucVu"] != DBNull.Value ? rw["IdChucVu"].ToString() : "";
                    //_Dpsuser.Email = rw["Email"] != DBNull.Value ? rw["Email"].ToString() : "";
                    //_Dpsuser.SDT = rw["PhoneNumber"] != DBNull.Value ? rw["PhoneNumber"].ToString() : "";
                    //_Dpsuser.IdDonVi = rw["IdDonVi"] != DBNull.Value ? int.Parse(rw["IdDonVi"].ToString()) : 0;
                    //_Dpsuser.Capcocau = rw["Capcocau"] != DBNull.Value ? int.Parse(rw["Capcocau"].ToString()) : 0;
                    //_Dpsuser.ID_Goc = rw["ID_Goc"] != DBNull.Value ? int.Parse(rw["ID_Goc"].ToString()) : 0;
                    //_Dpsuser.ID_Goc_Cha = rw["ID_Goc_Cha"] != DBNull.Value ? int.Parse(rw["ID_Goc_Cha"].ToString()) : 0;
                    //_Dpsuser.DonVi = rw["DonVi"] != DBNull.Value ? rw["DonVi"].ToString() : "";
                    //_Dpsuser.MaDinhDanh = rw["MaDinhDanh"] != DBNull.Value ? rw["MaDinhDanh"].ToString() : "";
                    //_Dpsuser.Active = rw["Active"] != DBNull.Value ? int.Parse(rw["Active"].ToString()) : 0;
                    //_Dpsuser.Avata = LiteController.genLinkAvatar(_config.LinkAPI, rw["Avata"]);
                    //_Dpsuser.LastUpdatePass = (DateTime)rw["LastUpdatePass"];
                    //_Dpsuser.IdTinh = long.Parse(_config.IdTinh);

                    //string str = "select * from Sys_Config where Code='EXP_PASS'";
                    //DataTable conf = Conn.CreateDataTable(str);
                    //if (conf != null && conf.Rows.Count > 0)
                    //{
                    //    int num = int.Parse(conf.Rows[0]["Value"].ToString());
                    //    if (num == 0)//k xét thời hạn
                    //        _Dpsuser.ExpDate = null;
                    //    else
                    //    {
                    //        DateTime exp = _Dpsuser.LastUpdatePass.AddDays(num + (int)rw["GiaHan"]);
                    //        _Dpsuser.ExpDate = exp;
                    //    }
                    //}
                    return(_Dpsuser);
                }
            }
            return(null);
        }
        public BaseModel <object> GetDSUser()
        {
            {
                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   = "";
                // string link = Data_API_MXH.Assets.Common.getDomain();

                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 * from TBL_Account", Conds);
                        //dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
                    }


                    //  status = 1;
                    var Data = 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"],

                        hinhanh = r["AVATAR"],
                        Avatar  = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),

                        //Occupation = r["occupation"],
                        //Phoned = r["Phone"],
                        //Address = r["Address"],
                    };

                    return(JsonResultCommon.ThanhCong(Data));
                }
                catch (Exception ex)
                {
                    return(JsonResultCommon.Exception(ex));
                }
            }
        }