public static int Add(FineStatuses finestatuses)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procFineStatuses_FineStatuses";
db.cmd.Parameters.AddWithValue("@FineStatusName", finestatuses.FineStatusName);
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);
}
private static List <FineStatuses> _GetListOfFineStatuses()
{
List <FineStatuses> FineStatuses = new List <FineStatuses>();
try
{
Command = @"select * from tblFineStatuses";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
FineStatuses singleFineStatuses = new FineStatuses();
singleFineStatuses.Id = (int)rdr[0];
singleFineStatuses.FineStatusName = rdr[1].ToString();
FineStatuses.Add(singleFineStatuses);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(FineStatuses);
}
public static int Add(StudentFines studentFines, FineStatuses fineStatuses)
{
int retvalue = -1;
studentFines.FineStatusesId = FineStatuses.Add(fineStatuses);
retvalue = StudentFines.Add(studentFines);
return(retvalue);
}
public static int Add(EmployeeFines employeeFines, FineStatuses fineStatuses)
{
int retvalue = -1;
employeeFines.FineStatusesId = FineStatuses.Add(fineStatuses);
retvalue = EmployeeFines.Add(employeeFines);
return(retvalue);
}
private static List <StudentFines> _GetStudentFines()
{
List <StudentFines> StudentFines = new List <StudentFines>();
try
{
Command = "select * from tblStudentFines";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
StudentFines singleStudentFines = new StudentFines();
singleStudentFines.Id = (int)rdr[0];
singleStudentFines.Fine = Convert.ToSingle(rdr[1]);
singleStudentFines.DateTime = Convert.ToDateTime(rdr[2]);
singleStudentFines.Note = rdr[3].ToString();
singleStudentFines.StudentsId = (int)rdr[4];
singleStudentFines.AddedByEmployeesId = (int)rdr[5];
singleStudentFines.FineStatusesId = (int)rdr[6];
var student = new Students();
singleStudentFines.Students = Students.ListOfStudents.SingleOrDefault(s => s.Id == singleStudentFines.StudentsId);
var finestatus = new FineStatuses();
singleStudentFines.FineStatus = FineStatuses.ListOfFineStatuses.SingleOrDefault(f => f.Id == singleStudentFines.FineStatusesId);
var emp = new Employees();
singleStudentFines.AddedByEmployees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleStudentFines.AddedByEmployeesId);
StudentFines.Add(singleStudentFines);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(StudentFines);
}
public static void Update(int id, FineStatuses finestatuses)
{
try
{
db.cmd.CommandText = "update tblFineStatuses set FineStatusName = @FineStatusName where Id=@id";
db.cmd.Parameters.AddWithValue("@FineStatusname", finestatuses.FineStatusName);
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 StudentFines()
{
Students = new Students();
FineStatus = new FineStatuses();
AddedByEmployees = new Employees();
}
public static void Update(int Id, StudentFines studentfines, FineStatuses finestatus)
{
studentfines.FineStatusesId = FineStatuses.Add(finestatus);
StudentFines.Update(Id, studentfines);
}
public static void Update(int Id, EmployeeFines empfine, FineStatuses finestatus)
{
empfine.FineStatusesId = FineStatuses.Add(finestatus);
EmployeeFines.Update(Id, empfine);
}
