public static List <Fee> GetFeesByType(Enums.FeeTypes type)
{
List <Fee> fees = new List <Fee>();
using (SqlConnection conn = new SqlConnection(Connection.StringConnection))
{
conn.Open();
using (SqlCommand comm = new SqlCommand("SELECT * FROM settings.fees WHERE Type = @Type", conn))
{
if (type == Enums.FeeTypes.TFee)
{
comm.Parameters.AddWithValue("@Type", "TFEE");
}
else if (type == Enums.FeeTypes.MFee)
{
comm.Parameters.AddWithValue("@Type", "MFEE");
}
else if (type == Enums.FeeTypes.OFee)
{
comm.Parameters.AddWithValue("@Type", "OFEE");
}
else if (type == Enums.FeeTypes.AFee)
{
comm.Parameters.AddWithValue("@Type", "AFEE");
}
else
{
comm.Parameters.AddWithValue("@Type", "");
}
using (SqlDataReader reader = comm.ExecuteReader())
{
while (reader.Read())
{
Fee fee = new Fee()
{
FeeID = Convert.ToInt32(reader["FeeID"]),
FeeDesc = Convert.ToString(reader["Fee"]),
FeeType = Convert.ToString(reader["Type"]),
YearLeveLID = Convert.ToInt16(reader["YearLevelID"]),
Amount = Convert.ToDouble(reader["Amount"]),
SchoolYearID = Convert.ToInt32(reader["SchoolYearID"])
};
fees.Add(fee);
}
}
}
}
return(fees);
}
public static List <Fee> GetFeesByType(Enums.FeeTypes type)
{
return(Fee_DS.GetFeesByType(type));
}
