public static List <clsContribution> getContributions(clsScheme Scheme)
{
SqlConnection con1 = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
List <clsContribution> listContribution = new List <clsContribution>();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con1.Open();
cmd.Connection = con1;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[SWITCHScheme_SchemeContributionsGet]";
cmd.Parameters.Add("@param_SchemeID", System.Data.SqlDbType.NVarChar).Value = Scheme.propSchemeID;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsContribution newContribution = new clsContribution();
newContribution.propClient = new clsClient(dr["ClientID"].ToString());
newContribution.propContributionAmount = float.Parse(dr["ContributionAmount"].ToString());
newContribution.propContributionID = dr["ContributionID"].ToString();
newContribution.propEndDate = dr["EndDate"] != System.DBNull.Value ? DateTime.Parse(dr["EndDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propIFAUpdatedBy = dr["IFAUpdatedBy"].ToString();
newContribution.propIFAUpdatedDate = dr["IFAUpdatedDate"] != System.DBNull.Value ? DateTime.Parse(dr["IFAUpdatedDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propScheme = Scheme;
newContribution.propSchemeContributionsUpdatedBy = dr["SchemeContributionsUpdatedBy"].ToString();
newContribution.propSchemeContributionsUpdatedDate = dr["SchemeContributionsUpdatedDate"] != System.DBNull.Value ? DateTime.Parse(dr["SchemeContributionsUpdatedDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propStartDate = dr["StartDate"] != System.DBNull.Value ? DateTime.Parse(dr["StartDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propValuationFrequency = dr["ValuationFrequency"].ToString();
listContribution.Add(newContribution);
}
con1.Close();
cmd.Dispose();
con1.Dispose();
return(listContribution);
}
public static List<clsContribution> getContributions(clsScheme Scheme) {
SqlConnection con1 = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
List<clsContribution> listContribution = new List<clsContribution>();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con1.Open();
cmd.Connection = con1;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[SWITCHScheme_SchemeContributionsGet]";
cmd.Parameters.Add("@param_SchemeID", System.Data.SqlDbType.NVarChar).Value = Scheme.propSchemeID;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsContribution newContribution = new clsContribution();
newContribution.propClient = new clsClient(dr["ClientID"].ToString());
newContribution.propContributionAmount = float.Parse(dr["ContributionAmount"].ToString());
newContribution.propContributionID = dr["ContributionID"].ToString();
newContribution.propEndDate = dr["EndDate"] != System.DBNull.Value ? DateTime.Parse(dr["EndDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propIFAUpdatedBy = dr["IFAUpdatedBy"].ToString();
newContribution.propIFAUpdatedDate = dr["IFAUpdatedDate"] != System.DBNull.Value ? DateTime.Parse(dr["IFAUpdatedDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propScheme = Scheme;
newContribution.propSchemeContributionsUpdatedBy = dr["SchemeContributionsUpdatedBy"].ToString();
newContribution.propSchemeContributionsUpdatedDate = dr["SchemeContributionsUpdatedDate"] != System.DBNull.Value ? DateTime.Parse(dr["SchemeContributionsUpdatedDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propStartDate = dr["StartDate"] != System.DBNull.Value ? DateTime.Parse(dr["StartDate"].ToString()) : DateTime.ParseExact("01/01/1800", "dd/MM/yyyy", null);
newContribution.propValuationFrequency = dr["ValuationFrequency"].ToString();
listContribution.Add(newContribution);
}
con1.Close();
cmd.Dispose();
con1.Dispose();
return listContribution;
}