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