public DataTable listMembers(DTOMember member)
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prc_ListarMiembros";
DataTable data = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
con.Open();
sda.Fill(data);
con.Close();
return(data);
}
public int deleteMember(DTOMember member)
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prc_EliminarMiembro";
cmd.Parameters.AddWithValue("@cedula", member.Member_Doc);
try
{
con.Open();
cmd.ExecuteNonQuery();
return(1);
}
catch (Exception ex)
{
Console.WriteLine("Error" + ex.Message);
con.Close();
return(0);
}
}
public int saveMember(DTOMember member)
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prc_AsignarMiembro";
cmd.Parameters.AddWithValue("@cedula", member.Member_Doc);
cmd.Parameters.AddWithValue("@cod_grupo", member.Member_Group);
cmd.Parameters.AddWithValue("@alias", member.Member_Nick);
try
{
con.Open();
cmd.ExecuteNonQuery();
return(1);
}
catch (SqlException ex)
{
Console.WriteLine("Error" + ex.Message);
con.Close();
return(0);
}
}
