private void DataPortal_Fetch(filterCriteria criteria)
{
this.RaiseListChangedEvents = false;
IsReadOnly = false;
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_common].[city_list]";
cm.Parameters.AddWithValue("@state", criteria.state);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
IsReadOnly = false;
if (criteria.set)
{
this.Add(new NameValuePair(string.Empty, "ALL"));
}
while (dr.Read())
{
this.Add(new NameValuePair(dr.GetString("city"), dr.GetString("city")));
}
IsReadOnly = true;
}
}
}
this.RaiseListChangedEvents = true;
}
private void DataPortal_Fetch(filterCriteria criteria)
{
this.RaiseListChangedEvents = false;
IsReadOnly = false;
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = string.Format("[app_common].[type_{0}_list]", criteria.Typename);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
IsReadOnly = false;
if (criteria.set)
{
this.Add(new NameValuePair(0, "All"));
}
while (dr.Read())
{
this.Add(new NameValuePair(dr.GetInt32("id"), dr.GetString("name")));
}
IsReadOnly = true;
}
}
}
this.RaiseListChangedEvents = true;
}
private void DataPortal_Fetch(filterCriteria criteria)
{
this.RaiseListChangedEvents = false;
IsReadOnly = false;
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "GetVisitTypeList";
cm.Parameters.AddWithValue("@div", criteria.div);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
IsReadOnly = false;
if (criteria.set)
{
this.Add(new NameValuePair(0, "All"));
}
else
{
this.Add(new NameValuePair(0, ""));
}
while (dr.Read())
{
this.Add(new NameValuePair(dr.GetInt32("id"), dr.GetString("name")));
}
IsReadOnly = true;
}
}
}
this.RaiseListChangedEvents = true;
}
private void DataPortal_Fetch(filterCriteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_member].[member_list]";
cm.Parameters.AddWithValue("@memberid", criteria.MemberId);
cm.Parameters.AddWithValue("@fullname", criteria.FullName);
cm.Parameters.AddWithValue("@lastName", criteria.Lastname);
cm.Parameters.AddWithValue("@enlastname", criteria.EnLastName);
cm.Parameters.AddWithValue("@firstname", criteria.Firstname);
cm.Parameters.AddWithValue("@enfirstname", criteria.EnFirstName);
cm.Parameters.AddWithValue("@married", criteria.Married);
cm.Parameters.AddWithValue("@agefrom", criteria.AgeFrom);
cm.Parameters.AddWithValue("@ageto", criteria.AgeTo);
cm.Parameters.AddWithValue("@city", criteria.City);
cm.Parameters.AddWithValue("@state", criteria.State);
cm.Parameters.AddWithValue("@status", criteria.Status);
cm.Parameters.AddWithValue("@regfrom", criteria.RegDateFrom.DBValue);
cm.Parameters.AddWithValue("@regto", criteria.RegDateTo.DBValue);
cm.Parameters.AddWithValue("@baptismfrom", criteria.BaptismFrom.DBValue);
cm.Parameters.AddWithValue("@baptismto", criteria.BaptismTo.DBValue);
cm.Parameters.AddWithValue("@birthfrom", criteria.BirthdayFrom.DBValue);
cm.Parameters.AddWithValue("@birthto", criteria.BirthdayTo.DBValue);
cm.Parameters.AddWithValue("@baptismId", criteria.BaptismId);
cm.Parameters.AddWithValue("@sex", criteria.Sex);
cm.Parameters.AddWithValue("@subdivision", criteria.SubDivision);
cm.Parameters.AddWithValue("@relationship", criteria.Relationship);
cm.Parameters.AddWithValue("@jobtype", criteria.JobType);
cm.Parameters.AddWithValue("@active", criteria.Active);
cm.Parameters.AddWithValue("@fellowship", criteria.Fellowship);
cm.Parameters.AddWithValue("@cellPhone", criteria.CellPhone);
cm.Parameters.AddWithValue("@home", criteria.Home);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
IsReadOnly = false;
while (dr.Read())
{
this.Add(new MemberInfo(dr));
}
IsReadOnly = true;
}
}
}
}
