public object deleteGroup(int id_group)
{
{
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
try
{
Conds.Add("ID_GROUP", id_group);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Delete(Conds, "TBL_GROUP") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object Delete_User(int id_group, int id_user)
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
try
{
Conds.Add("ID_GROUP", id_group);
Conds.Add("ID_USER", id_user);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Delete(Conds, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object deleteMedia(int id_media)
{
{
SqlConditions Conds = new SqlConditions();
SqlConditions Conds_tb = new SqlConditions();
DataTable dt = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
try
{
Conds_tb.Add("ID_MEDIA", id_media);
using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true))
{
//cnn.Delete(Conds_tb, "TBL_THONGBAO");
Thread.Sleep(500);
if (cnn.Delete(Conds_tb, "TBL_MEDIA") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object UpdateTrangCaNhan(Models.TrangCaNhan data)
{
{
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
val.Add("TieuSu", data.tieusu);
Conds.Add("ID_CANHAN", data.id_canhan);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Update(val, Conds, "TBL_TRANGCANHAN") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object deleteBaiTrangCaNhan(int id_baidangcanhan)
{
{
SqlConditions Conds = new SqlConditions();
SqlConditions Conds_tb = new SqlConditions();
DataTable dt = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
try
{
val.Add("COL_DISABLE", true);
Conds.Add("ID_BAIDANG_CANHAN", id_baidangcanhan);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Update(val, Conds, "TBL_BaiDang_TRANGCANHAN") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetUpdateQuyenLoaiBaiDang()
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
Conds.Add("id_user", loginData.Id);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
link = "http://192.168.43.236/";
// link = "http://192.168.3.49/";
//link = "https://*****:*****@id_user", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dt = cnn.CreateDataTable(@"SELECT ID_LOAIBAIDANG,TENLOAIBAIDANG
FROM TBL_LOAIBAIDANG
EXCEPT
SELECT lbd.ID_LOAIBAIDANG,TENLOAIBAIDANG
FROM TBL_NHOM_QUYEN_LOAIBAIDANG as lbd,TBL_LOAIBAIDANG as bd
WHERE ID_USER=@id_user and lbd.ID_LOAIBAIDANG=bd.ID_LOAIBAIDANG
", Conds);
}
var data = from r in dt.AsEnumerable()
select new
{
Id_LoaiDang = r["ID_LOAIBAIDANG"],
TenLoaiDang = r["TENLOAIBAIDANG"],
check = false,
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getTrangCaNhanFlow(int id_user)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select distinct ID_CANHAN,u.ID_USER,AnhBia,UserName,AVATAR,TieuSu
from TBL_TRANGCANHAN as cn, TBL_Account as u where cn.ID_USER=u.ID_USER and u.ID_USER="******"ID_CANHAN"],
Id_user = g["ID_USER"],
hinhanhbia = g["AnhBia"],
tieusu = g["TieuSu"],
anhbia = LiteController.genLinkImage_Post(_config.LinkAPI, g["AnhBia"]),
//media = g["TYPEPOST"],
//imgmedia = $"{link}/UploadedFiles/{g["TYPEPOST"]}",
//id_user = r["ID_USER"],
user_name = g["UserName"],
hinhanh = g["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, g["AVATAR"]),
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetDSNhanVien_PB(int id_phong)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
string sql = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
sql = @" select IDNV,pb.ID_PHONG,TENPHONG,CHUCVU,HOTEN,DIACHI,NGAYSINH,SDT,GIOITINH,NGAYVAOLAM from TBL_NHANVIEN as nv ,TBL_PHONGBAN as pb where nv.ID_PHONG=pb.ID_PHONG
";
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(sql, Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dr = dt.Select();
}
var data = from r in dr.AsEnumerable()
where
r["ID_PHONG"].Equals(id_phong)
select new
{
id_NV = r["IDNV"],
id_phong = r["ID_PHONG"],
hoten = r["HOTEN"],
chucvu = r["CHUCVU"],
diachi = r["DIACHI"],
ngaysinh = r["NGAYSINH"],
sdt = r["SDT"],
gioitinh = r["GIOITINH"],
// Roles = r["roles"],
tenphong = r["TENPHONG"],
ngayvaolam = r["NGAYVAOLAM"],
//Occupation = r["occupation"],
//Phoned = r["Phone"],
//Address = r["Address"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetDSUser_filter_InGroup(int id_gr)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
link = "http://192.168.43.236/";
//link = "http://192.168.3.49/";
// link = "https://*****:*****@"SELECT ID_USER,UserName,AVATAR
FROM TBL_Account
EXCEPT
select u.ID_USER,u.UserName,AVATAR from TBL_GROUPMEMBER as gm ,TBL_Account as u where GM.ID_USER=U.ID_USER and ID_GROUP=" + id_gr + "", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dr = dt.Select();
}
var data = from r in dr.AsEnumerable()
select new
{
ID_user = r["ID_USER"],
Username = r["UserName"],
// Roles = r["roles"],
hinhanh = r["AVATAR"],
Avatar = $"{link}/Avatar/{ r["AVATAR"]}",
//Occupation = r["occupation"],
//Phoned = r["Phone"],
//Address = r["Address"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetLuuTruKhenThuongUser()
{
{
int status = 0;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
string sql = @"
select bd.ID_BAIDANG,bd.TIEUDE,bd.NOIDUNG_BAIDANG,bd.CreatedDate,bd.CreatedBy,kt.TIEUDE AS TIEUDE_KT,kt.LINK_ICON,u.UserName,u.AVATAR from TBL_BAIDANG as bd,TBL_KHENTHUONG as kt,TBL_Account as u where bd.ID_KHENTHUONG
is not null and bd.ID_KHENTHUONG=kt.ID_KHENTHUONG and bd.CreatedBy=u.ID_USER
";
dt = cnn.CreateDataTable(sql, Conds);
dr = dt.Select();
}
var data = from r in dr.AsEnumerable()
select new
{
Id_BaiDang = r["ID_BAIDANG"],
tieude_baidang = r["TIEUDE"],
noidungbaidang = r["NOIDUNG_BAIDANG"],
createdate = r["CreatedDate"],
createby = r["CreatedBy"],
tieude_kt = r["TIEUDE_KT"],
icon_kt = r["LINK_ICON"],
user_name = r["UserName"],
hinhanh = r["AVATAR"],
avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
};
return(JsonResultCommon.ThanhCong(data));
//ID_khenthuong = r["ID_KHENTHUONG"],
//tieude = r["TIEUDE"],
//icon = r["LINK_ICON"],
//Noidungkt = r["NOIDUNG_KHEN_THUONG"],
//user_KT = r["USER_KT"],
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getGioiThieu()
{
int status = 0;
string Id = "";
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select ID_USER,u.IDNV,HOTEN,CHUCVU,DIACHI from TBL_Account as u , TBL_NHANVIEN as nv where u.IDNV=nv.IDNV and ID_USER="******"ID_USER"],
Id_nv = g["IDNV"],
hoten = g["HOTEN"],
//media = g["TYPEPOST"],
//imgmedia = $"{link}/UploadedFiles/{g["TYPEPOST"]}",
//id_user = r["ID_USER"],
chucvu = g["CHUCVU"],
diachi = g["DIACHI"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetDSUser_In_Group(int id_group)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt_group = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_group = cnn.CreateDataTable(@"
select ID_GROUP, U.ID_USER, QUYEN_ADMIN
, CREATE_DATE, IDNV, UserName, AVATAR from TBL_GROUPMEMBER AS G, TBL_Account AS U WHERE G.ID_USER = U.ID_USER and QUYEN_ADMIN=0 and ID_GROUP=" + id_group
, Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
}
var data = from r in dt_group.AsEnumerable()
select new
{
Id_group = r["ID_GROUP"],
id_user = r["ID_USER"],
id_nv = r["IDNV"],
Username = r["UserName"],
quyen_group = r["QUYEN_ADMIN"],
create_date = r["CREATE_DATE"],
// Roles = r["roles"],
//Address = r["Address"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetDSKhenThuongUser()
{
{
int status = 0;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
link = "http://192.168.3.49/";
string sql = @" select tk.ID_KHENTHUONG,NOIDUNG_KHEN_THUONG,TIEUDE,LINK_ICON,HOTEN from TBL_KHENTHUONG_USER as tk, TBL_Account as u,TBL_NHANVIEN as nv,TBL_KHENTHUONG as t where tk.USER_KT=u.ID_USER and u.IDNV=nv.IDNV and tk.ID_KHENTHUONG=t.ID_KHENTHUONG
";
dt = cnn.CreateDataTable(sql, Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dr = dt.Select();
//foreach (DataRow r in dr)
//{
// if (File.Exists(HttpContext.Current.Server.MapPath($"~/image/User/{r["ID_USER"]}.jpg")))
// {
// r["AVATAR"] = link + $"image/User/{r["ID_USER"]}.jpg";
// }
//}
}
var data = from r in dr.AsEnumerable()
select new
{
ID_khenthuong = r["ID_KHENTHUONG"],
noidung_kt = r["NOIDUNG_KHEN_THUONG"],
tieude = r["TIEUDE"],
hoten = r["HOTEN"],
icon = r["LINK_ICON"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object addGhim(int id_user, int id_thongdiep)
{
{
int status = 0;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
Hashtable val = new Hashtable();
Hashtable val2 = new Hashtable();
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
//val.Add("ID_COMMENT", data.id_cmt);
// val.Add("ID_BAIDANG", data.ID_BaiDang);
//val.Add("ID_THONGDIEP", id_thongdiep);
//val.Add("COL_DISABLE", true);
//val.Add("ID_USER", id_user);
val2.Add("COL_DISABLE", true);
//Conds.Add("ID_USER", id_user);
Conds.Add("ID_THONGDIEP", id_thongdiep);
//Conds.Add("ID_USER", data.ID_User);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
// dt = cnn.CreateDataTable(@"SELECT COL_DISABLE FROM TBL_THONGDIEPCEO as g where g.ID_THONGDIEP="+id_thongdiep, Conds);
// dr = dt.Select();
// var total = dt.Rows.Count;
if (cnn.Update(val2, Conds, "TBL_THONGDIEPCEO") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getDSThongDiepDetail(int id_td)
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select ID_THONGDIEP,TIEUDE,NOIDUNG,TYPEPOST,CreatedBy,CreatedDate,HOTEN,CHUCVU,AVATAR,COL_DISABLE from TBL_THONGDIEPCEO as td ,
TBL_USER as u,TBL_NHANVIEN as nv where u.ID_USER=td.CreatedBy and u.IDNV=nv.IDNV and ID_THONGDIEP=" + id_td, Conds);
}
var data = from g in dt.AsEnumerable()
select new
{
id_thongdiep = g["ID_THONGDIEP"],
title = g["TIEUDE"],
noidung = g["NOIDUNG"],
hoten = g["HOTEN"],
chucvu = g["CHUCVU"],
media = g["TYPEPOST"],
ghim = g["COL_DISABLE"],
imgmedia = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]),
//user_name = r["UserName"],
create_by = g["CreatedBy"],
createdate = g["CreatedDate"],
hinhanh = g["AVATAR"],
AlowEdit = g["CreatedBy"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, g["AVATAR"]),
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public BaseModel <object> GetDSUser_profile_change()
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"select ID_USER, u.IDNV,TINHTRANG, UserName, AVATAR, Pass, Email, nv.CHUCVU from TBL_Account as u, TBL_NHANVIEN as nv where u.IDNV = nv.IDNV and u.ID_USER="******"select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
}
var data = from r in dt.AsEnumerable()
select new
{
ID_user = r["ID_USER"],
Username = r["UserName"],
Password = r["Pass"],
Email = r["Email"],
chucvu = r["CHUCVU"],
hinhanh = r["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
TinhTrang = r["TINHTRANG"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public async Task <BaseModel <object> > Logout()
{
string Token = lc.GetHeader(Request);
var user = lc._GetInfoUser(Token);
if (user == null)
{
return(JsonResultCommon.DangNhap());
}
logHelper.Log(5, user.Id, "Đăng xuất");
return(JsonResultCommon.ThanhCong());
}
public object UpdateUserName(Models.User.Account data)
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
val.Add("TINHTRANG", data.TinhTrang);
Conds.Add("ID_USER", loginData.Id);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Update(val, Conds, "TBL_Account") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
dt = cnn.CreateDataTable("select * from TBL_Account", Conds);
}
var dl = from r in dt.AsEnumerable()
select new
{
ID_user = r["ID_USER"],
ID_NV = r["IDNV"],
Username = r["UserName"],
Password = r["Pass"],
Email = r["Email"],
Token = r["Token"],
TinhTrang = r["TINHTRANG"],
// Roles = r["roles"],
Avatar = r["AVATAR"],
};
// mangxahoi.PushToAllUsers_CheckOnline(dl, null);
return(JsonResultCommon.ThanhCong(dl));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object Create_TrangCanNhan()
{
{
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
DataTable dt_tb = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
string tam = "";
int id_user = 0;
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
//val.Add("ID_COMMENT", data.id_cmt);
// val.Add("ID_BAIDANG", data.ID_BaiDang);
//Conds.Add("ID_USER", data.ID_User);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_tb = cnn.CreateDataTable(@"SELECT Max(ID_USER) as asLastID FROM TBL_Account");
dr = dt_tb.Select();
tam = dt_tb.Rows[0]["asLastID"].ToString();
id_user = Int32.Parse(tam);
Thread.Sleep(500);
val.Add("ID_USER", id_user);
if (cnn.Insert(val, "TBL_TRANGCANHAN") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object CheckFlow(int id_canhan)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int total;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_count = new DataTable();
DataTable dt_user = new DataTable();
DataTable checkflow = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
checkflow = cnn.CreateDataTable(@" select ID_CANHAN from TBL_Flow where USER_Flow=" + loginData.Id + " and ID_CANHAN=" + id_canhan, Conds);
}
total = checkflow.Rows.Count;
if (total > 0)
{
return(new
{
check = true
});
}
else
{
return(new
{
check = false
});
}
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetUserProfile()
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@" select ID_USER,nv.IDNV,UserName,AVATAR,DIACHI,NGAYSINH,SDT,GIOITINH from TBL_Account as u ,TBL_NHANVIEN as nv where u.IDNV=nv.IDNV and ID_USER="******"ID_USER"],
ID_NV = r["IDNV"],
Username = r["UserName"],
hinhanh = r["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
diachi = r["DIACHI"],
ngaysinh = r["NGAYSINH"],
sdt = r["SDT"],
gioitinh = r["GIOITINH"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getDSGhim(int id_user)
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
SELECT * FROM TBL_GHIM as g,TBL_THONGDIEPCEO as td where g.ID_THONGDIEP=td.ID_THONGDIEP and ID_USER="******"ID_THONGDIEP"],
title = g["TIEUDE"],
noidung = g["NOIDUNG"],
media = g["TYPEPOST"],
imgmedia = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]),
//id_user = r["ID_USER"],
//user_name = r["UserName"],
create_by = g["CreatedBy"],
createdate = g["CreatedDate"],
//hinhanh = g["AVATAR"],
//AlowEdit = g["CreatedBy"],
//Avatar = $"{link}/Avatar/{ g["AVATAR"]}",
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetPhanQuyenLoaiBaiDang()
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
Conds.Add("id_user", loginData.Id);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
//dt = cnn.CreateDataTable("select * from TBL_NHOM_QUYEN_LOAIBAIDANG, TBL_NHOM_QUYEN_USER, TBL_LOAIBAIDANG where TBL_NHOM_QUYEN_LOAIBAIDANG.ID_QUYEN = TBL_NHOM_QUYEN_USER.ID_QUYEN and TBL_NHOM_QUYEN_LOAIBAIDANG.ID_LOAIBAIDANG = TBL_LOAIBAIDANG.ID_LOAIBAIDANG and ID_USER =@id_user", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dt = cnn.CreateDataTable("select * from TBL_NHOM_QUYEN_LOAIBAIDANG as qbd,TBL_LOAIBAIDANG as loai where qbd.ID_LOAIBAIDANG = loai.ID_LOAIBAIDANG and ID_USER =@id_user", Conds);
dr = dt.Select();
}
var data = from r in dr.AsEnumerable()
select new
{
Id_LoaiDang = r["ID_LOAIBAIDANG"],
TenLoaiDang = r["TENLOAIBAIDANG"],
Icon_BaiDang = r["LINK_ICON_BAIDANG"],
Icon_app = r["ICON_APP"],
check = true,
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetDSKhenThuong()
{
{
int status = 0;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
link = "http://192.168.3.49/";
dt = cnn.CreateDataTable("select * from TBL_KHENTHUONG", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dr = dt.Select();
//foreach (DataRow r in dr)
//{
// if (File.Exists(HttpContext.Current.Server.MapPath($"~/image/khenthuong/{r["ID_KHENTHUONG"]}.jpg")))
// {
// r["ICON_APP"] = link + $"image/khenthuong/{r["ID_KHENTHUONG"]}.jpg";
// }
//}
}
var data = from r in dr.AsEnumerable()
select new
{
ID_khenthuong = r["ID_KHENTHUONG"],
tieude = r["TIEUDE"],
icon = r["LINK_ICON"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetDS_MyMedia(int id_usser)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true))
{
dt = cnn.CreateDataTable(@"
select ID_MEDIA,HINHANH,template,TIEUDE,CreatedBy,CreatedDate,UserName,AVATAR from TBL_MEDIA as me,TBL_Account as u where me.CreatedBy=u.ID_USER
and me.CreatedBy=" + id_usser + "order by ID_MEDIA DESC"
, Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
}
var data = from r in dt.AsEnumerable()
select new
{
id_media = r["ID_MEDIA"],
img_media = r["HINHANH"],
template = r["template"],
hinhanh = LiteController.genLinkImage_Media(_config.LinkAPI, r["HINHANH"]),
title = r["TIEUDE"],
createdate = r["CreatedDate"],
createby = r["CreatedBy"],
username = r["UserName"],
hinhanh_user = r["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public BaseModel <object> ResetSession()
{
BaseModel <object> _baseModel = new BaseModel <object>();
string Token = lc.GetHeader(Request);
var user = lc._GetInfoUser(Token);
if (user == null)
{
return(JsonResultCommon.DangNhap());
}
var reset = lc.RefreshJSONWebToken(ref user);
user.accessToken = reset;
return(JsonResultCommon.ThanhCong(user));
}
public object UpdateQuyenLoaiBaiDang(int loai)
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
Hashtable val = new Hashtable();
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
val.Add("ID_LOAIBAIDANG", loai);
val.Add("ID_USER", loginData.Id);
if (cnn.Insert(val, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
return(JsonResultCommon.ThanhCong());
}
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getRanDoomAnh()
{
int status = 0;
string Id = "";
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select TOP 1 * from TBL_BAIDANG where CreatedBy=" + loginData.Id + " and TYPEPOST !=null or TYPEPOST!='' ORDER BY NEWID() ", Conds);
}
var data = from g in dt.AsEnumerable()
select new
{
img = g["TYPEPOST"],
hinhanh = LiteController.genLinkImage_Post(_config.LinkAPI, g["TYPEPOST"]),
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object UpdateGhim(int id_user, int id_thongdiep)
{
int status = 0;
string Id = "";
int id_group = 0;
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
Hashtable val = new Hashtable();
Hashtable val_member = new Hashtable();
DataTable dt_token = new DataTable();
DataTable lastid = new DataTable();
string sqlq = "";
try
{
using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true))
{
val.Add("COL_DISABLE", false);
Conds.Add("ID_THONGDIEP", id_thongdiep);
if (cnn.Update(val, Conds, "TBL_THONGDIEPCEO") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object UpdateThongDiep(Models.ThongDiepCEO data)
{
int status = 0;
string Id = "";
int id_group = 0;
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
Hashtable val = new Hashtable();
Hashtable val_member = new Hashtable();
DataTable dt_token = new DataTable();
DataTable lastid = new DataTable();
string sqlq = "";
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
val.Add("TIEUDE", data.title);
val.Add("NOIDUNG", data.noidung);
Conds.Add("ID_THONGDIEP", data.id_thongdiep);
if (cnn.Update(val, Conds, "TBL_THONGDIEPCEO") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
