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")); }