public static int Add(StudentAttendanceStatuses studentattendancestatuses)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procStudentAttendanceStatuses_AddStudentAttendanceStatuses";
db.cmd.Parameters.AddWithValue("@StatusName", studentattendancestatuses.StatusName);
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 List <StudentAttendanceStatuses> _GetStudentAttendanceStatuses()
{
List <StudentAttendanceStatuses> StudentAttendanceStatuses = new List <StudentAttendanceStatuses>();
try
{
Command = "select * from tblStudentAttendanceStatuses";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
StudentAttendanceStatuses singleStudentAttendanceStatuses = new StudentAttendanceStatuses();
singleStudentAttendanceStatuses.Id = (int)rdr[0];
singleStudentAttendanceStatuses.StatusName = rdr[1].ToString();
StudentAttendanceStatuses.Add(singleStudentAttendanceStatuses);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(StudentAttendanceStatuses);
}
public static int Add(StudentAttendanceRecords studentAttendanceRecords, StudentAttendanceStatuses studentAttendanceStatuses)
{
int retvalue = -1;
studentAttendanceRecords.StudentAttendanceStatusesId = StudentAttendanceStatuses.Add(studentAttendanceStatuses);
retvalue = StudentAttendanceRecords.Add(studentAttendanceRecords);
return(retvalue);
}
public static void Update(int id, StudentAttendanceStatuses studentattendancestatuses)
{
try
{
db.cmd.CommandText = "update tblStudentAttendanceStatuses set StatusName = @StatusName where Id=@id";
db.cmd.Parameters.AddWithValue("@Statusname", studentattendancestatuses.StatusName);
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);
}
}
private static List <StudentAttendanceRecords> _GetStudentAttendanceRecords()
{
List <StudentAttendanceRecords> StudentAttendanceRecords = new List <StudentAttendanceRecords>();
try
{
Command = "select * from tblStudentAttendanceRecords";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
StudentAttendanceRecords singleStudentAttendanceRecords = new StudentAttendanceRecords();
singleStudentAttendanceRecords.Id = (int)rdr[0];
singleStudentAttendanceRecords.Date = rdr[1].ToString();
singleStudentAttendanceRecords.StudentsId = (int)rdr[2];
singleStudentAttendanceRecords.StudentAttendanceStatusesId = (int)rdr[3];
var student = new Students();
singleStudentAttendanceRecords.Students = Students.ListOfStudents.SingleOrDefault(s => s.Id == singleStudentAttendanceRecords.StudentsId);
var Sas = new StudentAttendanceStatuses();
singleStudentAttendanceRecords.StudentAttendanceStatuses = Sas.ListOfStudentAttendanceStatuses.SingleOrDefault(s => s.Id == singleStudentAttendanceRecords.StudentAttendanceStatusesId);
StudentAttendanceRecords.Add(singleStudentAttendanceRecords);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(StudentAttendanceRecords);
}
public StudentAttendanceRecords()
{
Students = new Students();
StudentAttendanceStatuses = new StudentAttendanceStatuses();
}
