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