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