public static bool insertGroupUser(GroupUserDTO pUserGroupDTO) { using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString)) { SqlCommand command = new SqlCommand("usp_insert_groupUser", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("@user_id", SqlDbType.Int); command.Parameters["@user_id"].Value = pUserGroupDTO.user_id; command.Parameters.Add("@group_id", SqlDbType.Int); command.Parameters["@group_id"].Value = pUserGroupDTO.id_group; command.Connection.Open(); try { int result = command.ExecuteNonQuery(); if (result != 0) { return(true); } } catch (Exception e) { } return(false); }; }
public ActionResult _DeleteGroupUser(string group_id, string user_id) { GroupUserDTO groupUserDTO = new GroupUserDTO(); groupUserDTO.id_group = group_id; groupUserDTO.user_id = user_id; if (groupProvider.deleteGroupUser(groupUserDTO).Result) { return(new HttpStatusCodeResult(200)); } return(new HttpStatusCodeResult(404, "Can't find that")); }
public async Task <bool> deleteGroupUser(GroupUserDTO groupUserDTO) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(_BaseAddress); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken()); HttpResponseMessage response = client.DeleteAsync("api/groups/members/?id_group=" + groupUserDTO.id_group + "&id_user=" + groupUserDTO.user_id).Result; if (response.IsSuccessStatusCode) { return(true); } return(false); } }
public bool UpdateGroupUser(GroupUserDTO groupuser) { this.ConnectToDatabase(); string Query = "update GROUPUSER set GROUP_ID='" + groupuser.GroupId + "',USER_ID = '" + groupuser.UserId; //This is command class which will handle the query and connection object. MySqlCommand command = new MySqlCommand(Query, mySQLConnection); command.ExecuteNonQuery(); this.Close(); return(true); }
public bool InsertGroupUser(GroupUserDTO groupuser) { this.ConnectToDatabase(); string Query = "insert into GROUPUSER values('" + groupuser.GroupId + "','" + groupuser.UserId + "');"; //This is command class which will handle the query and connection object. MySqlCommand command = new MySqlCommand(Query, mySQLConnection); command.ExecuteNonQuery(); this.Close(); return(true); }
public ActionResult _AddGroupUsers(string id_group, List <string> selected_userGroup_id) { if (ModelState.IsValid) { //Getting data to post List <GroupUserDTO> groupUserDTOList = new List <GroupUserDTO>(); foreach (var user_id in selected_userGroup_id) { GroupUserDTO groupUserDTO = new GroupUserDTO(); groupUserDTO.id_group = id_group; groupUserDTO.user_id = user_id; groupUserDTOList.Add(groupUserDTO); } //Post List <GroupUserDTO> groupUsersAdded = new List <GroupUserDTO>(); List <GroupUserDTO> groupUserError = new List <GroupUserDTO>(); groupUsersAdded = groupProvider.postUsersGroups(groupUserDTOList).Result; if (groupUsersAdded.Count != 0) { //Compare and get not added users foreach (var user_added in groupUsersAdded) { bool isAdded = false; foreach (var user_id in selected_userGroup_id) { if (user_id == user_added.user_id) { isAdded = true; break; } } if (!isAdded) { groupUserError.Add(user_added); groupUsersAdded.Remove(user_added); } } // creates a json to return result var result = new { usersAdded = groupUsersAdded, usersError = groupUserError, viewHtml = PartialView("/Views/Users/_Group/_GroupUsersList.cshtml", new Model.GroupModel(id_group)).RenderToString() }; return(Json(result)); } } return(new HttpStatusCodeResult(404, "Repeated users")); }
public GroupUserDTO GetGroupUser(int id) { GroupUserDTO groupUser; this.ConnectToDatabase(); MySqlCommand command = this.mySQLConnection.CreateCommand(); command.CommandText = "SELECT * FROM GROUPUSER WHERE GROUPUSER_ID = " + id; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int groupId = reader.GetInt32(0); int userId = reader.GetInt32(1); groupUser = new GroupUserDTO(groupId, userId); return(groupUser); } this.Close(); return(null); }
public List <GroupUserDTO> GetAllGroupUser() { List <GroupUserDTO> listGroupUser = new List <GroupUserDTO>(); this.ConnectToDatabase(); MySqlCommand command = this.mySQLConnection.CreateCommand(); command.CommandText = "SELECT * FROM GROUPUSER "; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int groupId = reader.GetInt32(0); int userId = reader.GetInt32(1); GroupUserDTO groupuser = new GroupUserDTO(groupId, userId); listGroupUser.Add(groupuser); } this.Close(); return(listGroupUser); }