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