public List <ParishionerData> Listar(string dataType, int parishId)
{
var conn = new SqlConnection();
var command = new SqlCommand();
var dataBase = new DBConnect();
var Lista = new List <ParishionerData>();
try
{
conn = dataBase.Open();
command.Connection = conn;
command.CommandText = "ListParishionerData";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@DataType", dataType);
command.Parameters.AddWithValue("@ParishionerId", parishId);
var rdr = command.ExecuteReader();
while (rdr != null && rdr.Read())
{
var reg = new ParishionerData();
reg.Data = (string)rdr["Data"];
Lista.Add(reg);
}//while
}
catch (Exception e)
{
MessageBox.Show(String.Concat(e.Message, e.StackTrace), "");
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
return(Lista);
}
public Parishioner()
{
_parishionerData = new ParishionerData();
}
