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