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