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); }