public object getGioiThieuFlow(int id)
{
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 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 GetDetailMedia(int _idmedia)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select 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 ID_MEDIA=" + _idmedia
, 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"],
hinhanh = LiteController.genLinkImage_Media(_config.LinkAPI, r["HINHANH"]),
title = r["TIEUDE"],
createdate = r["CreatedDate"],
template = r["template"],
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 object DeleteGhim(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);
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.Delete(Conds, "TBL_GHIM") < 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 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));
}
}
public object GetRanDomTop2KhenThuong()
{
{
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))
{
dt = cnn.CreateDataTable(@"
SELECT TOP 2 bd.ID_BAIDANG,bd.ID_KHENTHUONG,kt.TIEUDE as kttd,bd.TIEUDE as bdtieude,kt.LINK_ICON FROM TBL_BAIDANG as bd ,TBL_KHENTHUONG as kt where bd.ID_KHENTHUONG=kt.ID_KHENTHUONG and ID_LOAIBAIDANG=2
ORDER BY NEWID()
", Conds);
dr = dt.Select();
}
var data = from r in dr.AsEnumerable()
select new
{
id_baidang = r["ID_BAIDANG"],
ID_khenthuong = r["ID_KHENTHUONG"],
tieudekt = r["kttd"],
tieudebaidang = r["bdtieude"],
icon = r["LINK_ICON"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetNVNotUser()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@" SELECT IDNV,HOTEN
FROM TBL_NHANVIEN
EXCEPT
SELECT u.IDNV,HOTEN
FROM TBL_Account as u,TBL_NHANVIEN as nv where u.IDNV=nv.IDNV
", Conds);
}
var data = from r in dt.AsEnumerable()
select new
{
id_nv = r["IDNV"],
hoten = r["HOTEN"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object getRanDomDSThongDiep()
{
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 TOP 1 ID_THONGDIEP,TIEUDE,CreatedDate FROM TBL_THONGDIEPCEO ORDER BY NEWID()
", Conds);
}
var data = from g in dt.AsEnumerable()
select new
{
id_thongdiep = g["ID_THONGDIEP"],
title = g["TIEUDE"],
createdate = g["CreatedDate"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetrandomDSUser()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"SELECT TOP 4 ID_USER,UserName,AVATAR FROM TBL_Account where TINHTRANG=1
ORDER BY NEWID()", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
}
var Data = from r in dt.AsEnumerable()
select new
{
ID_user = r["ID_USER"],
hinhanh = r["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
Username = r["UserName"],
};
return(JsonResultCommon.ThanhCong(Data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object Update_quyen_Memmber(int id_user, Models.Group.User_Group 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
{
val.Add("QUYEN_ADMIN", data.quyen_group);
Conds.Add("ID_GROUP", data.Id_Group);
Conds.Add("ID_USER", id_user);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Update(val, Conds, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong("Cập nhật thành công !"));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object DeleteFlow(int id_canhan)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
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();
DataTable dt_token = new DataTable();
try
{
Conds.Add("ID_CANHAN", id_canhan);
Conds.Add("USER_Flow", loginData.Id);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Delete(Conds, "TBL_Flow") < 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 UpdateGroup(Models.Group.Group 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();
try
{
val.Add("TEN_GROUP", data.ten_group);
val.Add("UPDATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val.Add("UPDATE_BY", data.CreatedBy);
Conds.Add("ID_GROUP", data.id_group);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Update(val, 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 getDSGhim()
{
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,COL_DISABLE FROM TBL_GHIM ", Conds);
}
var data = from g in dt.AsEnumerable()
select new
{
id_thongdiep = g["ID_THONGDIEP"],
ghim = g["COL_DISABLE"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object getDSLike()
{
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))
{
dt = cnn.CreateDataTable("select * from TBL_LIKE", Conds);
}
var data = from r in dt.AsEnumerable()
select new
{
ID_like = r["ID_LIKE"],
title_like = r["title"],
link_icon_like = r["LINK_ICON"],
Disabled_icon = r["Disabled_icon"],
//Icon_app = r["ICON_APP"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object GetIDMedia()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt = cnn.CreateDataTable(@"
select ID_MEDIA from TBL_MEDIA"
, 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"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object GetMenu()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_submenu = 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 * from TBL_Menu
", Conds);
dt_submenu = cnn.CreateDataTable(@"
select * from TBL_Submenu
", 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_menu = r["id_menu"],
title = r["title"],
icon_menu = r["icon_menu"],
page = r["page"],
submenu = from sub in dt_submenu.AsEnumerable()
where sub["id_submenu"].Equals(r["id_menu"])
select new
{
title_submenu = sub["title_submenu"],
icon_submenu = sub["icon_submenu"],
page = sub["page"],
}
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
}
public object UpdateQuyenLoaiBaiDang_Default()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
int id_user;
DataTable lastid = new DataTable();
bool Visible = true;
Hashtable val = new Hashtable();
Hashtable val2 = 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))
{
Thread.Sleep(500);
lastid = cnn.CreateDataTable(@"
SELECT Max(ID_USER) as asLastID FROM TBL_USER");
dr = lastid.Select();
Id = lastid.Rows[0]["asLastID"].ToString();
id_user = Int32.Parse(Id);
val.Add("ID_LOAIBAIDANG", 6);
//val.Add("ID_LOAIBAIDANG", 1);
val.Add("ID_USER", id_user);
if (cnn.Insert(val, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
val2.Add("ID_LOAIBAIDANG", 1);
//val.Add("ID_LOAIBAIDANG", 1);
val2.Add("ID_USER", id_user);
if (cnn.Insert(val2, "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 getDSGroup()
{
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_user = 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 = "https://*****:*****@"
select g.ID_GROUP,TEN_GROUP,u.ID_USER,gu.QUYEN_ADMIN,g.CREATE_DATE as ngaytaogroup,CREATE_BY ,u.UserName,u.IDNV,u.AVATAR from TBL_GROUP as g,TBL_GROUPMEMBER as gu,TBL_Account as u
where u.ID_USER=gu.ID_USER and g.ID_GROUP=gu.ID_GROUP and u.ID_USER="******"select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
dr = dt.Select();
}
var data = from r in dt.AsEnumerable()
// where r["ID_USER"].Equals(loginData.Id)
select new
{
ID_group = r["ID_GROUP"],
Ten_Group = r["TEN_GROUP"],
id_user = r["ID_USER"],
id_nhanvien = r["IDNV"],
user_name = r["UserName"],
quyen_group = r["QUYEN_ADMIN"],
Create_date = r["ngaytaogroup"],
Create_by = r["CREATE_BY"],
avatar_user = r["AVATAR"]
//Icon_app = r["ICON_APP"],
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object addGroup(Models.Group.Group data)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
int id_group = 0;
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
{
val.Add("TEN_GROUP", data.ten_group);
val.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val.Add("CREATE_BY", loginData.Id);
val.Add("UPDATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
sqlq = "select TEN_GROUP from TBL_GROUP where TEN_GROUP='" + data.ten_group + "'";
dt = cnn.CreateDataTable(sqlq);
if (dt.Rows.Count == 0)
{
if (cnn.Insert(val, "TBL_GROUP") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
else
{
return(JsonResultCommon.ThatBai("Tên Nhóm Đã Tồn Tại", cnn.LastError));
}
lastid = cnn.CreateDataTable(@"
SELECT TOP 1 ID_GROUP asLastID FROM TBL_GROUP ORDER BY ID_GROUP DESC");
dr = lastid.Select();
foreach (DataRow r in dr[0].Table.Rows)
{
Id = r["asLastID"].ToString();
}
id_group = Int32.Parse(Id);
val_member.Add("ID_GROUP", id_group);
val_member.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val_member.Add("ID_USER", loginData.Id);
val_member.Add("QUYEN_ADMIN", 1);
if (cnn.Insert(val_member, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong(id_group));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object getDSUser_Group(int id_group)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_group = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_group = cnn.CreateDataTable(@" select * from TBL_GROUP as g, TBL_GROUPMEMBER as u where g.ID_GROUP=u.ID_GROUP");
dt = cnn.CreateDataTable(@"
select gu.ID_GROUP,g.TEN_GROUP,u.ID_USER,QUYEN_ADMIN,gu.CREATE_DATE as
ngaythamgia,UserName,AVATAR,TINHTRANG from TBL_GROUPMEMBER as gu,TBL_Account as u ,
TBL_GROUP as g where gu.ID_USER=u.ID_USER and gu.ID_GROUP=g.ID_GROUP
", Conds);
//dt_token = cnn.CreateDataTable("select * from LoginSection where Token = @token and Id = @Id_nv", Conds);
}
var data = from g in dt_group.AsEnumerable()
where g["ID_GROUP"].Equals(id_group) && g["ID_USER"].ToString() == loginData.Id.ToString()
select new
{
ID_group = g["ID_GROUP"],
Ten_Group = g["TEN_GROUP"],
id_user = g["ID_USER"],
//id_user = r["ID_USER"],
//user_name = r["UserName"],
quyen_group = g["QUYEN_ADMIN"],
//Create_date = r["ngaythamgia"],
//tinhtrang = r["TINHTRANG"],
//avatar_user = r["AVATAR"]
//Icon_app = r["ICON_APP"],
Group_member = from r in dt.AsEnumerable()
where r["ID_GROUP"].Equals(g["ID_GROUP"])
select new
{
id_user = r["ID_USER"],
user_name = r["UserName"],
Create_date = r["ngaythamgia"],
tinhtrang = r["TINHTRANG"],
hinhanh = r["AVATAR"],
avatar_user = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
//Icon_app = r["ICON_APP"],
},
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public static string Join(List <SqlFieldValuePair> pairs, SqlConditions condition)
{
return(string.Join(" " + condition.ToString() + " ", pairs));
}
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));
}
}
/// <summary>
/// Cập nhật quy trình theo bước<para/>
/// Quy trình kết thúc khi next=-1
/// https://dpscomvn.visualstudio.com/Webcore%20version%202/_workitems/edit/16344/
/// </summary>
/// <param name="IdStep"></param>
/// <param name="Next"></param>
/// <param name="UserID"></param>
/// <param name="note"></param>
/// <returns></returns>
public bool Update(int IdStep, int Next, long UserID, string note, Boolean IsComeBack = false)
{
SqlConditions cond = new SqlConditions();
cond.Add(new SqlCondition("Id", Id));
cond.Add(new SqlCondition("IdStep", IdStep));
cond.Add(new SqlCondition("Next", Next));
cond.Add(new SqlCondition("Passed", 0));
cond.Add(new SqlCondition("IsComeBack", IsComeBack));
string sql = @"select * from DP_Process
where Id = @Id and IdStep=@IdStep ";
sql += " select IdRow from DP_Process p where Id = @Id and IdStep=@IdStep and Next=@Next and IsComeBackPro = @IsComeBack and (select count(*) from DP_Process_Detail d where p.IdRow=d.IdProcess and Checked=1 and Passed=0)=0";
sql += " select * from Tbl_PhanAnhGopY where IsDel=0 and Id=@Id";
DataSet ds = cnn.CreateDataSet(sql, cond);
if (ds == null)
{
Error = "Có gì đó không đúng, vui lòng thử lại sau";
return(false);
}
if (ds.Tables[2] == null || ds.Tables[2].Rows.Count == 0)
{
Error = "Phản ánh không tồn tại";
return(false);
}
if (ds.Tables[0] == null || ds.Tables[0].Rows.Count == 0 || ds.Tables[1] == null || ds.Tables[1].Rows.Count == 0)
{
Error = "Không tìm thấy bước xử lý hoặc bước xử lý đã được thực hiện";
return(false);
}
DateTime now = DateTime.Now;
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string idProcess = dr["IdRow"].ToString();
//Đánh dấu đã xử lý các DP_Process_Detail này
Hashtable valPassed = new Hashtable();
valPassed.Add("Passed", 1);
if (IdLS == 0)
{
valPassed.Add("IdLS", DBNull.Value);
}
else
{
valPassed.Add("IdLS", IdLS);
}
valPassed.Add("CheckDate", now);
cnn.Update(valPassed, new SqlConditions()
{
{ "IdProcess", idProcess }, { "Passed", 0 }
}, "DP_Process_Detail");
}
;
//cập nhật checker cho process này vào bảng DP_Process_Detail
Hashtable val = new Hashtable();
val.Add("Checked", 1);
val.Add("CheckNote", note);
cnn.Update(val, new SqlConditions()
{
{ "IdProcess", ds.Tables[1].Rows[0][0].ToString() }, { "Checker", UserID }
}, "DP_Process_Detail");
//tìm checkers tiếp theo khi chưa hoàn tất
if (Next != -1)
{
List <string> lstUserPos = new List <string>();
string lstUser = "";
sql = "exec sp_FindXuLyTiepTheo_Checker @Id ,@IdStep ,@Next,@IsComeBack ";
DataSet dsNext = cnn.CreateDataSet(sql, new SqlConditions {
{ "Id", Id }, { "IdStep", IdStep }, { "Next", Next }, { "IsComeBack", IsComeBack }
});
DataTable dtNext = dsNext.Tables[0];
foreach (DataRow dr in dtNext.Rows)//1, 3 IdStep=2
{
List <string> lst = GetCheckers(dr["IdStep"].ToString(), dr["Next"].ToString(), Convert.ToBoolean(dr["IsComeBackPro"]));
if (!string.IsNullOrEmpty(Error))
{
return(false);
}
if (lst.Count > 0 && dr["IdForm"].ToString() != "6")
{
///huy thi k can thong bao
lstUserPos.AddRange(lst);
}
foreach (string id in lst)
{
Hashtable val1 = new Hashtable();
val1["IdProcess"] = dr["IdRow"];
val1["Checker"] = id;
cnn.Insert(val1, "DP_Process_Detail");
if (cnn.LastError != null)
{
return(false);
}
}
}
if (lstUserPos.Count > 0)
{
lstUserPos = lstUserPos.Distinct().ToList();
}
lstUser = string.Join(",", lstUserPos);
if (string.IsNullOrEmpty(lstUser))
{
string str58 = @" select distinct UserID from Tbl_User_GroupUser gu inner join Dps_UserGroupRoles gr on gu.IdGroupUser=gr.IdGroupUser
inner join Dps_Roles on IdRole = gr.IDGroupRole
inner join DPS_User u on u.UserID = gu.IdUser
inner join v_QuyenUser qu on qu.IdUser=u.UserID and qu.IdRole=Dps_Roles.IdRole
where Dps_Roles.IdRole = 1084 and Deleted = 0 and u.Active =1 ";
DataTable dtUser58 = cnn.CreateDataTable(str58);
var temp = dtUser58.AsEnumerable().Select(x => x["UserID"].ToString()).ToList();
lstUser = string.Join(",", temp);
}
}
return(true);
}
public object addUserGroup(int id_group, int id_user, Models.Group.User_Group data)
{
string sqlq = "";
SqlConditions Conds = new SqlConditions();
sqlq = "select * from TBL_GROUPMEMBER where ID_USER="******" and ID_GROUP=" + id_group;
bool value = true;
DataRow[] dr;
int re = 0;
int id_gr = 0;
Hashtable val_member = new Hashtable();
string Id = "";
DataTable lastid = new DataTable();
Hashtable val = new Hashtable();
try
{
//string Token = Request.Headers.GetValues("Token").FirstOrDefault();
//LoginData loginData = API_KD.Assets.Common.GetUserByToken(Token);
//if (loginData == null)
// return JsonResultCommon.DangNhap();
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Thread.Sleep(500);
DataTable dt = cnn.CreateDataTable(sqlq);
if (cnn.LastError != null || dt == null)
{
return(JsonResultCommon.Exception(cnn.LastError));
}
if (dt.Rows.Count == 0 && id_group != 0)
{
val.Add("ID_GROUP", data.Id_Group);
val.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val.Add("ID_USER", id_user);
val.Add("QUYEN_ADMIN", data.quyen_group);
re = cnn.Insert(val, "TBL_GROUPMEMBER");
}
else if (data.Id_Group == 0 || id_group == 0)
{
lastid = cnn.CreateDataTable(@"
SELECT TOP 1 ID_GROUP asLastID FROM TBL_GROUP ORDER BY ID_GROUP DESC");
dr = lastid.Select();
foreach (DataRow r in dr[0].Table.Rows)
{
Id = r["asLastID"].ToString();
}
id_gr = Int32.Parse(Id);
val_member.Add("ID_GROUP", id_gr);
val_member.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val_member.Add("ID_USER", id_user);
val_member.Add("QUYEN_ADMIN", 1);
if (cnn.Insert(val_member, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
else
{
return(JsonResultCommon.ThatBai("Thành viên đã tồn tại !", cnn.LastError));
}
return(JsonResultCommon.ThanhCong());
}
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public BaseModel <object> GetCreateUser(Models.User.Account data)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
Hashtable val_user = new Hashtable();
Hashtable val = new Hashtable();
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
string name;
bool check;
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_user = cnn.CreateDataTable(@"
select Email from TBL_Account
", Conds);
dr = dt_user.Select();
if (dpsUserMr.ktma(data.email.ToString()) == false)
{
val.Add("IDNV", data.IDNV);
val.Add("Email", data.email);
val.Add("UserName", data.username);
val.Add("Pass", data.pass);
val.Add("TINHTRANG", data.TinhTrang);
}
else
{
val.Add("IDNV", data.IDNV);
val.Add("Email", data.email + "hufi");
val.Add("UserName", data.username);
val.Add("Pass", data.pass);
val.Add("TINHTRANG", data.TinhTrang);
return(JsonResultCommon.Trung("Tài khoản" + data.email));
//val.Add("IDNV", data.IDNV);
//val.Add("Email", data.email);
//val.Add("UserName", data.username);
//val.Add("Pass", data.pass);
//val.Add("TINHTRANG", data.TinhTrang);
}
if (cnn.Insert(val, "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));
}
}
}
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 BaseModel <object> DS_ThanhVien_Group(int id_group, [FromBody] QueryRequestParams p)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Dictionary <string, string> _sortableFields = new Dictionary <string, string>
{
{ "Username", "Username" },
//{ "DonViTinh", "DonViTinh" }
};
Panigator v_panigator = null;
IDictionary <string, string> v_dic_keyFilter = new Dictionary <string, string>
{
{ "Username", "Username" },
//{ "DonViTinh", "DonViTinh"},
};
string _select = "", _sqlQuery = "", v_str_paginate = "", _orderBy = "", _whereCondition = "";
SqlConditions _cond = new SqlConditions();
#region Filter, sort, paganitor
//filter request have to right and enough , same in code
if (p.Filter != null)
{
if (p.Filter.Count > 0)
{
var listKeySearch = p.Filter.Where(x => !v_dic_keyFilter.ContainsKey(x.Key)).Select(q => q.Key).ToList();
if (listKeySearch != null && listKeySearch.Count > 0)
{
return(JsonResultCommon.NotData());
}
foreach (string _filter in p.Filter.Keys)
{
if (!string.IsNullOrEmpty(p.Filter[_filter]))
{
foreach (string vl in p.Filter.Values)
{
//_whereCondition += " AND " + v_dic_keyFilter[_filter] + " = @" + _filter;
_whereCondition += " AND " + v_dic_keyFilter[_filter] + " LIKE'%";
_whereCondition += vl;
_whereCondition += "%'";
_cond.Add(_filter, p.Filter[_filter]);
}
}
}
}
}
//sort column in datatable
if (p.Sort != null)
{
if (!string.IsNullOrEmpty(p.Sort.ColumnName) && v_dic_keyFilter.ContainsKey(p.Sort.ColumnName))
{
_orderBy = v_dic_keyFilter[p.Sort.ColumnName] + " " + (p.Sort.Direction.ToLower().Equals("asc") ? "asc" : "desc");
}
}
int page_index = 0;
//set up panigator for datatable
if (p.Panigator != null)
{
//v_str_paginate = $@" OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY;";
//// offset fetch là các tùy chọn của mệnh đề order by
//_cond.Add("PageSize", p.Panigator.PageSize);
//_cond.Add("PageNumber", p.Panigator.PageIndex);
page_index = p.Panigator.PageIndex;
}
#endregion
_sqlQuery = $@" select ID_GROUP, U.ID_USER, QUYEN_ADMIN
, CREATE_DATE, IDNV, UserName, AVATAR from TBL_GROUPMEMBER AS G, TBL_Account AS U
WHERE G.ID_USER = U.ID_USER and ID_GROUP=" + id_group + "" + _whereCondition + "";
DataTable _datatable = cnn.CreateDataTable(_sqlQuery, _cond);
int _countRows = _datatable.Rows.Count;
if (cnn.LastError != null || _datatable == null)
{
return(JsonResultCommon.NotData());
}
if (_datatable.Rows.Count == 0)
{
return(JsonResultCommon.NotData());
}
else
{
if (page_index == 0)
{
p.Panigator.PageSize = _countRows;
}
v_panigator = new Panigator(p.Panigator.PageIndex, p.Panigator.PageSize, _datatable.Rows.Count);
}
var _data = from r in _datatable.AsEnumerable().Skip((p.Panigator.PageIndex - 1) * p.Panigator.PageSize).Take(p.Panigator.PageSize).ToList()
select new
{
Id_group = r["ID_GROUP"],
id_user = r["ID_USER"],
id_nv = r["IDNV"],
Username = r["UserName"],
quyen_group = r["QUYEN_ADMIN"],
create_date = r["CREATE_DATE"],
hinhanh = r["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, r["AVATAR"]),
};
return(JsonResultCommon.ThanhCong(_data, v_panigator));
}
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object getFlow(int id_canhan)
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_count = new DataTable();
DataTable dt_user = new DataTable();
DataTable checkflow = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "";
DataTable dt_token = new DataTable();
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_user = cnn.CreateDataTable(@"select top 4 USER_Flow from TBL_Flow where ID_CANHAN=" + id_canhan + "ORDER by newid()", Conds);
dt = cnn.CreateDataTable(@" select ID_USER,AVATAR,TINHTRANG from TBL_Account ");
dt_count = cnn.CreateDataTable(@"select count(ID_CANHAN) as tong,ID_CANHAN from TBL_Flow where ID_CANHAN=" + id_canhan + "group by ID_CANHAN");
}
var data = from g in dt_count.AsEnumerable()
select new
{
tong = g["tong"],
Flow = from cnt in dt_user.AsEnumerable()
select new
{
user_flow = cnt["USER_Flow"],
TT_User_Flow = from flow in dt.AsEnumerable()
where flow["ID_USER"].Equals(cnt["USER_Flow"])
select new
{
TinhTrang = flow["TINHTRANG"],
hinh = flow["AVATAR"],
Avatar = LiteController.genLinkAvatar(_config.LinkAPI, flow["AVATAR"]),
},
},
};
return(JsonResultCommon.ThanhCong(data));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
