public async Task <object> UpdateAvatarUser([FromBody] Models.ImageModel data) { string Token = lc.GetHeader(Request); LoginData loginData = lc._GetInfoUser(Token); if (loginData == null) { return(JsonResultCommon.DangNhap()); } DataTable lastid = new DataTable(); DataRow[] dr; string Id = ""; Hashtable val = new Hashtable(); //!string.IsNullOrEmpty(data.image.ToString()) //Data_API_MXH.Assets.Common.getDomain(); if (data.image != null) { string base64 = data.image.ToString(); string filename = data.name; int so = 0; int baidang; try { string x = ""; var fl_name = UploadHelper.UploadImageAvatar(base64, filename, null, _hostingEnvironment.ContentRootPath, ref x, true); try { //Conds.Add("email", Email); //Conds.Add("password", Pass); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { SqlConditions Conds = new SqlConditions(); Thread.Sleep(500); val.Add("AVATAR", fl_name); Conds.Add("ID_USER", loginData.Id); if (cnn.Update(val, Conds, "TBL_Account") < 0) { return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError)); } } return(JsonResultCommon.ThanhCong()); } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } catch (Exception ex) { return(JsonResultCommon.Exception(ex)); } } return(JsonResultCommon.ThatBai("Cập nhật thất bại")); }
public object getDSBaiDangTrangCaNhan([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=" + loginData.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 = cnn.CreateDataTable(sql); dt_baidangcanhan = cnn.CreateDataTable(sql_baidang, 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 "); } 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"].Equals(p["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"], // 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(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"], // 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(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"], // 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(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)); } }