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