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 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 object deleteBaiDangChiaSe(int id_baidangcanhan) { { SqlConditions Conds = new SqlConditions(); DataTable dt = new DataTable(); Hashtable val = new Hashtable(); DataTable dt_token = new DataTable(); try { Conds.Add("ID_BAIDANG", id_baidangcanhan); using (DpsConnection cnn = new DpsConnection(_config.ConnectionString)) { if (cnn.Delete(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 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 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 DeleteQuyenLoaiBaiDang(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)) { Conds.Add("ID_USER", loginData.Id); Conds.Add("ID_LOAIBAIDANG", loai); if (cnn.Delete(Conds, "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 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 DeleteThongDiep(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(_config.ConnectionString)) { Conds.Add("ID_THONGDIEP", id_thongdiep); if (cnn.Delete(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)); } }