public static void Update(int id, FeeSchedules feeschedules)
{
try
{
db.cmd.CommandText = @"update tblFeeSchedules set FEE = @fee,
Grade_ID=@gradeid,
FeeType_ID=@feetypeid
where Id=@id; ";
db.cmd.Parameters.AddWithValue("@fee", feeschedules.Fee);
db.cmd.Parameters.AddWithValue("@gradeid", feeschedules.GradesId);
db.cmd.Parameters.AddWithValue("@feetypeid", feeschedules.FeeTypesId);
db.cmd.Parameters.AddWithValue("@id", id);
db.con.Open();
db.cmd.ExecuteNonQuery();
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
}
public static int Add(FeeSchedules feeSchedules)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procFeeSchedules_AddFeeSchedules";
db.cmd.Parameters.AddWithValue("@Fee", feeSchedules.Fee);
db.cmd.Parameters.AddWithValue("@Grade_ID", feeSchedules.GradesId);
db.cmd.Parameters.AddWithValue("@FeeType_ID", feeSchedules.FeeTypesId);
db.cmd.Parameters.Add("@id", SqlDbType.Int);
db.cmd.Parameters["@id"].Direction = ParameterDirection.Output;
db.con.Open();
db.cmd.ExecuteNonQuery();
retvalue = Convert.ToInt32(db.cmd.Parameters["@id"].Value);
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
return(retvalue);
}
public static int Add(FeeSchedules feeSchedules, FeeTypes feeTypes)
{
int retvalue = -1;
feeSchedules.FeeTypesId = FeeTypes.Add(feeTypes);
retvalue = FeeSchedules.Add(feeSchedules);
return(retvalue);
}
private static List <FeeSchedules> _GetListOfFeeSchedules()
{
List <FeeSchedules> FeeSchedules = new List <FeeSchedules>();
try
{
Command = @"select * from tblFeeSchedules fees join tblGrades gds
on fees.Grade_ID=gds.Id join tblFeeTypes fts
on fees.FeeType_ID=fts.Id";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
FeeSchedules singleFeeSchedules = new FeeSchedules();
singleFeeSchedules.Id = (int)rdr[0];
singleFeeSchedules.Fee = Convert.ToSingle(rdr[1]);
singleFeeSchedules.GradesId = (int)rdr[2];
singleFeeSchedules.FeeTypesId = (int)rdr[3];
//
var grades = new Grades();
singleFeeSchedules.Grades = Grades.ListOfGrades.SingleOrDefault(gr => gr.Id == singleFeeSchedules.GradesId);
//
//singleFeeSchedules.Grades.Id = (int)rdr[4];
//singleFeeSchedules.Grades.GradeName = rdr[5].ToString();
//
var feetype = new FeeTypes();
singleFeeSchedules.FeeType = FeeTypes.ListOfFeeTypes.SingleOrDefault(ft => ft.Id == singleFeeSchedules.FeeTypesId);
//
//singleFeeSchedules.FeeType.Id = (int)rdr[6];
//singleFeeSchedules.FeeType.FeeTypeName = rdr[7].ToString();
FeeSchedules.Add(singleFeeSchedules);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(FeeSchedules);
}
private static List <FeeRecords> _getListOfFeeRecords()
{
List <FeeRecords> FeeRecords = new List <FeeRecords>();
try
{
Command = @"select * from tblFeeRecords;";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
FeeRecords singleFeeRecords = new FeeRecords();
singleFeeRecords.Id = (int)rdr[0];
singleFeeRecords.DateTime = rdr[1].ToString();
singleFeeRecords.Paid = Convert.ToBoolean(rdr[2].ToString());
singleFeeRecords.AddedByEmployeesId = (int)rdr[3];
singleFeeRecords.StudentsId = (int)rdr[4];
singleFeeRecords.FeeSchedulesId = (int)rdr[5];
Students std = new Students();
FeeSchedules fsch = new FeeSchedules();
Employees emp = new Employees();
singleFeeRecords.Employee = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleFeeRecords.AddedByEmployeesId);
singleFeeRecords.Students = Students.ListOfStudents.SingleOrDefault(s => s.Id == singleFeeRecords.StudentsId);
singleFeeRecords.FeeSchedules = FeeSchedules.ListOfFeeSchedules.SingleOrDefault(f => f.Id == singleFeeRecords.FeeSchedulesId);
FeeRecords.Add(singleFeeRecords);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(FeeRecords);
}
public static void Update(int Id, FeeSchedules feeschedules, Grades grades)
{
feeschedules.GradesId = Grades.Add(grades);
FeeSchedules.Update(Id, feeschedules);
}
public FeeRecords()
{
Employee = new Employees();
Students = new Students();
FeeSchedules = new FeeSchedules();
}
