Exemplo n.º 1
0
 public static void Update(int id, StudentFines studentfines)
 {
     try
     {
         db.cmd.CommandText = @"update tblStudentFines set Fine = @fine, 
             DateTime=@datetime,
         Note=@note,
         Student_ID=@student_id,
         AddedByEmployee_ID=@addedbyemployeeid,
         FineStatus_ID=@finestatusid
             where Id=@id";
         db.cmd.Parameters.AddWithValue("@fine", studentfines.Fine);
         db.cmd.Parameters.AddWithValue("@datetime", studentfines.DateTime);
         db.cmd.Parameters.AddWithValue("@note", studentfines.Note);
         db.cmd.Parameters.AddWithValue("@student_id", studentfines.StudentsId);
         db.cmd.Parameters.AddWithValue("@addedbyemployeeid", studentfines.AddedByEmployeesId);
         db.cmd.Parameters.AddWithValue("@finestatusid", studentfines.FineStatusesId);
         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);
     }
 }
Exemplo n.º 2
0
        public static int Add(StudentFines studentFines)
        {
            int retvalue = -1;

            try
            {
                db.cmd.CommandType = CommandType.StoredProcedure;
                db.cmd.CommandText = "procStudentFines_AddStudentFines";
                db.cmd.Parameters.AddWithValue("@Fine", studentFines.Fine);
                db.cmd.Parameters.AddWithValue("@DateTime", studentFines.DateTime);
                db.cmd.Parameters.AddWithValue("@Note", studentFines.Note);
                db.cmd.Parameters.AddWithValue("@Student_ID", studentFines.StudentsId);
                db.cmd.Parameters.AddWithValue("@AddedByEmployee_ID", studentFines.AddedByEmployeesId);
                db.cmd.Parameters.AddWithValue("@FineStatus_ID", studentFines.FineStatusesId);
                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);
        }
Exemplo n.º 3
0
        public static int Add(StudentFines studentFines, FineStatuses fineStatuses)
        {
            int retvalue = -1;

            studentFines.FineStatusesId = FineStatuses.Add(fineStatuses);
            retvalue = StudentFines.Add(studentFines);
            return(retvalue);
        }
Exemplo n.º 4
0
        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);
        }
Exemplo n.º 5
0
 public static void Update(int Id, StudentFines studentfines, FineStatuses finestatus)
 {
     studentfines.FineStatusesId = FineStatuses.Add(finestatus);
     StudentFines.Update(Id, studentfines);
 }