public static List <IndividualSupplementary> GetFormIndividualSupplementary(int branchID, string criteria, string supplementaryType) { var dbUtil = new DatabaseManager(); var payees = new List <IndividualSupplementary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetPCFFormIndividualSupplementary"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDMasLocation", branchID); cmd.Parameters.AddWithValue("@strCriteria", criteria); cmd.Parameters.AddWithValue("@strSupplementaryType", supplementaryType); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var payee = new IndividualSupplementary { IndividualSupplementaryID = ReferenceEquals(reader["intIndividualSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSupplementaryID"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), SupplementaryID = ReferenceEquals(reader["intSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryID"]), SupplementaryName = ReferenceEquals(reader["strSupplementaryName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSupplementaryName"]), SupplementaryTypeID = ReferenceEquals(reader["intSupplementaryTypeID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryTypeID"]), COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]), COAName = ReferenceEquals(reader["strCOAName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOAName"]) }; payees.Add(payee); } return(payees); } } } }
public static List <IndividualSupplementary> GetIndividualSupplementary() { var dbUtil = new DatabaseManager(); var supplementaries = new List <IndividualSupplementary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetPCFIndvSupplementary"; cmd.CommandTimeout = 180; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var supplementary = new IndividualSupplementary { IndividualSupplementaryID = ReferenceEquals(reader["intIndividualSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSupplementaryID"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), SupplementaryID = ReferenceEquals(reader["intSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryID"]), SupplementaryTypeID = ReferenceEquals(reader["intSupplementaryTypeID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryTypeID"]), COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]) }; supplementaries.Add(supplementary); } return(supplementaries); } } } }