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