/// <summary>
/// reset mật khẩu
/// </summary>
/// <param name="iduser"></param>
/// <param name="password"></param>
/// <returns></returns>
//public string ResetPass(string iduser, string password)
//{
// using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
// {
// var Tb = Conn.CreateDataSet(@"select * from Dps_User where UserID = @Id
// select * from Sys_Config where Code='SEND_MAIL_RESET_PASS'", new SqlConditions() { { "Id", iduser } });
// if (Tb == null || Tb.Tables[0].Rows.Count != 1)
// return "Tài khoản không tồn tại";
// string newpass = EncryptPassword(password);
// var val = new Hashtable();
// val.Add("PasswordHash", newpass);
// val.Add("LastUpdatePass", DateTime.Now);
// val.Add("GiaHan", 0);
// Conn.BeginTransaction();
// if (Conn.Update(val, new SqlConditions { new SqlCondition("UserID", iduser) }, "Dps_User") != 1)
// {
// Conn.RollbackTransaction();
// return "Không thể thay đổi mật khẩu";
// }
// #region gửi mail
// try
// {
// if (Tb.Tables[1].Rows.Count > 0)
// {
// if (Tb.Tables[1].Rows[0]["Value"].ToString() == "1")
// {
// if (string.IsNullOrEmpty(Tb.Tables[0].Rows[0]["Email"].ToString()))
// {
// Conn.RollbackTransaction();
// return "Không thể thay đổi mật khẩu";// "Người dùng không có thông tin Email";
// }
// string Error = "";
// //string strHTML = System.IO.File.ReadAllText(_config.LinkAPI + Constant.TEMPLATE_IMPORT_FOLDER + "/User_ForgetPass.html");
// Hashtable kval = new Hashtable();
// kval.Add("{{NewPass}}", password);
// kval.Add("$nguoinhan$", Tb.Tables[0].Rows[0]["Fullname"]);
// kval.Add("$SysName$", _config.SysName);
// MailAddressCollection Lstcc = new MailAddressCollection();
// MailInfo minfo = new MailInfo(MailConfig.Value, int.Parse(Tb.Tables[0].Rows[0]["IdDonVi"].ToString()));
// if (minfo.Id > 0)
// {
// string fileTemp = Path.Combine(_hostingEnvironment.ContentRootPath, Constant.TEMPLATE_IMPORT_FOLDER + "/User_ForgetPass.html");
// var rs = SendMail.Send(fileTemp, kval, Tb.Tables[0].Rows[0]["Email"].ToString(), "RESET MẬT KHẨU NGƯỜI DÙNG", Lstcc, Lstcc, null, false, out Error, minfo);
// if (!string.IsNullOrEmpty(Error))
// {
// Conn.RollbackTransaction();
// return "Không thể thay đổi mật khẩu";//"Gửi mail thất bại";
// }
// }
// }
// }
// }
// catch (Exception ex)
// {
// Conn.RollbackTransaction();
// return "Không thể thay đổi mật khẩu";// "Gửi mail thất bại";
// }
// #endregion
// Conn.EndTransaction();
// return "";
// }
//}
/// <summary>
/// kiểm tra người dùng có tồn tại
/// </summary>
/// <param name="UserNameorID">id người dùng hoặc tên đăng nhập</param>
/// <param name="loai">0: kiểm tra bằng ID, 1: username</param>
/// <returns></returns>
public bool CheckNguoiDung(string UserNameorID, int loai)
{
DataTable Tb = null;
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
{
SqlConditions sqlcond = new SqlConditions();
string sqlq = "";
if (loai == 1)
{
sqlcond.Add("UserName", UserNameorID);
sqlq = "select [UserID] from Dps_User where Deleted = 0 and UserName = @UserName";
}
if (loai == 0)
{
sqlcond.Add("Id", UserNameorID);
sqlq = "select [UserID] from Dps_User where Deleted = 0 and UserID = @Id";
}
Tb = Conn.CreateDataTable(sqlq, sqlcond);
}
if (Tb.Rows.Count == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// Lấy danh sách nhóm quyền của nhóm người dùng
/// </summary>
/// <param name="group"></param>
/// <returns></returns>
public Dictionary <int, List <int> > GetGroupRole_Roles(List <int> group)
{
Dictionary <int, List <int> > dic = new Dictionary <int, List <int> >();
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) //db QLPA
{
for (int i = 0; i < group.Count; i++)
{
int idusergroup = group[i];
string sql = @"select g.IDGroupUser,g.IDGroupRole,r.RoleGroupName
from Dps_RoleGroups r
inner join Dps_UserGroupRoles g on g.IDGroupRole=r.GroupID
where IDGroupUser=@IDGroupUser";
DataTable dt = Conn.CreateDataTable(sql, new SqlConditions {
{ "IDGroupUser", idusergroup }
});
if (Conn.LastError != null || dt == null)
{
return(null);
}
var slist = new List <int>();
foreach (DataRow r in dt.Rows)
{
slist.Add(int.Parse(r["IDGroupRole"].ToString()));
}
dic.Add(idusergroup, slist);
}
}
return(dic);
}
/// <summary>
/// đổi mật khẩu
/// </summary>
/// <param name="iduser">id người dùng</param>
/// <param name="oldpassword">mật khẩu cũ</param>
/// <param name="password">mật khẩu mới</param>
/// <returns></returns>
public BaseModel <object> ChangePass(string iduser, string oldpassword, string password)
{
if (string.IsNullOrEmpty(password) || password.Length < 6)
{
return(JsonResultCommon.Custom("Mật khẩu mới quá ngắn"));
}
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
{
var Tb = Conn.CreateDataTable("select PasswordHash from Dps_User where UserID = @Id", new SqlConditions()
{
{ "Id", iduser }
});
if (Tb == null || Tb.Rows.Count != 1)
{
return(JsonResultCommon.KhongTonTai());
}
if (!oldpassword.Equals(DecryptPassword(Tb.Rows[0]["PasswordHash"].ToString())))
{
return(JsonResultCommon.Custom("Mật khẩu cũ không chính xác"));
}
string newpass = EncryptPassword(password);
var val = new Hashtable();
val.Add("PasswordHash", newpass);
val.Add("LastUpdatePass", DateTime.Now);
val.Add("GiaHan", 0);
if (Conn.Update(val, new SqlConditions {
new SqlCondition("UserID", iduser)
}, "Dps_User") != 1)
{
return(JsonResultCommon.SQL(Conn.LastError.Message));
}
return(JsonResultCommon.ThanhCong());
}
}
/// <summary>
/// Lấy danh sách nhóm người dùng
/// </summary>
/// <param name="IdUser"></param>
/// <returns></returns>
public List <int> GetUserGroup(string IdUser)
{
DataTable Tb = null;
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString)) //db QLPA
{
string sqlq = @"select distinct a.IdUser,b.IdGroup,b.GroupName
from Tbl_User_GroupUser a
inner join Dps_User u on a.IdUser=a.IdUser
inner join Dps_UserGroups b on b.IdGroup=a.IdGroupUser
where a.IdUser=@IdUser
";
//string sqlq = "exec [spn_GetRoleByUser] @UserID";
Tb = Conn.CreateDataTable(sqlq, new SqlConditions()
{
{ "IdUser", IdUser }
});
if (Conn.LastError != null || Tb == null)
{
return(null);
}
}
var slist = new List <int>();
foreach (DataRow r in Tb.Rows)
{
slist.Add(int.Parse(r["IdGroup"].ToString()));
}
return(slist);
}
/// <summary>
/// Chỉ lấy tất cả quyền của user
/// </summary>
/// <param name="IdUser"></param>
/// <returns></returns>
public List <long> GetRules(long IdUser, int VaiTro)
{
DataTable Tb = null;
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
{
string sqlq = @"select distinct ug.IdUser,r.IdRole,r.Role
from Dps_User_GroupUser ug
inner join Dps_UserGroupRoles gr on gr.IDGroupUser=ug.IdGroupUser
inner join Dps_Roles r on r.IdRole=gr.IDGroupRole
where ug.IdUser=@UserID and r.Disabled=0";
sqlq += " and ug.Locked=0 and ug.Disabled=0 and ug.IdGroupUser=@VaiTro";
//string sqlq = "exec [spn_GetRoleByUser] @UserID";
Tb = Conn.CreateDataTable(sqlq, new SqlConditions()
{
{ "UserID", IdUser }, { "VaiTro", VaiTro }
});
if (Tb == null)
{
return(null);
}
}
var slist = new List <long>();
foreach (DataRow r in Tb.Rows)
{
slist.Add(long.Parse(r["IdRole"].ToString()));
}
return(slist);
}
public bool ktma(string ma)
{
DataTable dt_user = new DataTable();
DataRow[] dr;
SqlConditions Conds = new SqlConditions();
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_user = cnn.CreateDataTable(@"
select Email from TBL_Account
", Conds);
dr = dt_user.Select();
for (int i = 0; i < dt_user.Rows.Count; i++)
{
if (dt_user.Rows[i]["Email"].ToString() == ma)
{
return(true);
}
}
return(false);
//var nv = qlks.TAIKHOANs.Where(t => t.TENTK == ma).FirstOrDefault();
//if (nv == null)
//{
// return false;
//}
//return true;
}
}
/// <summary>
/// kiểm tra email người dùng có tồn tại
/// </summary>
/// <param name="email">email</param>
/// <param name="UserId">0: khi insert, 1: khi update</param>
/// <returns></returns>
public bool CheckEmail(string email, long UserId)
{
DataTable Tb = null;
using (DpsConnection Conn = new DpsConnection(_config.ConnectionString))
{
SqlConditions sqlcond = new SqlConditions();
string sqlq = "";
string idstr = "";
sqlcond.Add("email", email);
if (UserId > 0)
{
idstr = " and UserID <> @Id";
sqlcond.Add("Id", UserId);
}
sqlq = $"select [UserID] from Dps_User where Deleted = 0 {idstr} and Email=@email";
Tb = Conn.CreateDataTable(sqlq, sqlcond);
}
if (Tb.Rows.Count == 1)
{
return(true);
}
return(false);
}
/// <summary>
///
/// </summary>
/// <param name="type">1: Update, 2: Check, 3: Get</param>
/// <param name="request">reqtest json khi bắn API</param>
/// <param name="response">response json khi API trả về</param>
/// <param name="ErrorCode">ErrorCode</param>
/// <param name="ErrorMessage">ErrorMessage</param>
/// <returns></returns>
public bool LogJeedocs(int type, string request, string response, string ProcessCode, string ProcessMessage, int idUser, bool Success)
{
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Hashtable val = new Hashtable();
//val.Add("type", Loai);
val.Add("ProcessCode", ProcessCode);
val.Add("ProcessMessage", ProcessMessage);
val.Add("ResponseJson", response);
val.Add("Request", request);
val.Add("Type", type);
val.Add("Success", Success);
val.Add("CreatedBy", idUser);
val.Add("CreatedDate", DateTime.Now);
int kq = cnn.Insert(val, "Tbl_JeeDocs_Log");
cnn.Disconnect();
if (kq == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{ return(false); }
}
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 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 Task onDisconnectToken(string infoToken)
{
try
{
TokenRequesModel infoDataCon = JsonConvert.DeserializeObject <TokenRequesModel>(infoToken);
string Token = infoDataCon.Token;
string idUser = infoDataCon.UserID.ToString();
string clientID = checkClientIDWithToken(Token);
if (!ConnectedClients.ContainsKey(Token))
{
ConnectedClients[Token] = clientID;
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
SqlConditions val = new SqlConditions();
val.Add("Token", Token);
cnn.Delete(val, "SignalR_Connect");
ConnectedClients.Remove(Token);
}
}
}
catch (Exception ex)
{
return(base.OnDisconnectedAsync(ex));
}
return(base.OnDisconnectedAsync(new Exception()));
}
public Task ReconnectToken(string infoToken)
{
try
{
TokenRequesModel infoDataCon = JsonConvert.DeserializeObject <TokenRequesModel>(infoToken);
string Token = infoDataCon.Token;
string idUser = infoDataCon.UserID.ToString();
string clientID = checkClientIDWithToken(Token);
if (!ConnectedClients.ContainsKey(Token))
{
ConnectedClients[Token] = clientID;
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Hashtable has = new Hashtable();
has.Add("Token", Token);
has.Add("TimeTokenConnect", DateTime.Now);
SqlConditions cond = new SqlConditions();
cond.Add("ConnectionId", clientID);
if (cnn.Update(has, cond, "SignalR_Connect") == 1)
{
}
}
}
//return base.OnConnected();
}
catch (Exception ex)
{
return(base.OnDisconnectedAsync(ex));
}
return(base.OnConnectedAsync());
}
public bool LogImport(long idUser, string text = "")
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
DataTable dt = cnn.CreateDataTable("select * from Tbl_Log_Loai where IdRow=" + Loai);
if (dt == null || dt.Rows.Count == 0)
{
Error = "Loại đối tượng không đúng";
return(false);
}
string ip = _accessor.HttpContext.Connection.RemoteIpAddress.ToString();
Hashtable val = new Hashtable();
val.Add("IdLoaiLog", Loai);
val.Add("IdHanhDong", 7);
val.Add("IP", ip);
val.Add("NoiDung", "Import danh sách " + dt.Rows[0]["LoaiLog"].ToString().ToLower() + " " + text);
val.Add("CreatedBy", idUser);
val.Add("CreatedDate", DateTime.Now);
int kq = cnn.Insert(val, "Tbl_Log");
cnn.Disconnect();
if (kq == 1)
{
return(true);
}
else
{
return(false);
}
}
}
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 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 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 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 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 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 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 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 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 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 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 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 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));
}
}
}
