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