public void LoadStudentsOfSelectedActivity(ListBox list, object selectedActivity)
{
list.Items.Clear();
Activity selected = selectedActivity as Activity;
List <ActivityPayment> payments = new List <ActivityPayment>();
ActivityPaymentAccess context = new ActivityPaymentAccess();
foreach (ActivityPayment item in selected.ActivityPayments)
{
ActivityPayment fullPayment = context.Get(item.Id);
payments.Add(fullPayment);
}
selected.ActivityPayments = payments;
StudentLogic studentLogic = new StudentLogic();
List <Student> allStudents = studentLogic.GetAllStudents();
List <Student> listStudentsOfSelectedActivity = new List <Student>();
foreach (Student item in allStudents)
{
if (!StudentHasAlreadyPaid(item, selected.ActivityPayments))
{
list.Items.Add(item);
}
}
if (list.Items.Count == 0)
{
throw new NoStudentsInSystemException("No hay estudiantes en el sistema para pagar esa actividad");
}
}
public IEnumerable <StudentsDetail> GetAllStudent()
{
List <StudentsDetail> studentsDetailList = new List <StudentsDetail>();
StudentLogic studentLogicBL = new StudentLogic();
return(studentLogicBL.getStudentList());
}
public ListDisciplineWindow(StudentLogic studentLogic, ReportLogic reportLogic)
{
this.studentLogic = studentLogic;
this.reportLogic = reportLogic;
InitializeComponent();
logger = LogManager.GetCurrentClassLogger();
}
public void GetBasicBestRoutes()
{
SetUp();
StudentLogic testLogic = new StudentLogic();
SchoolVanLogic schoolVanLogic = new SchoolVanLogic();
Student newStudent = TestStudent(1);
newStudent.Id = testLogic.GetNextIdFree() - 1;
testLogic.Add(newStudent);
SchoolVanLogic logic = new SchoolVanLogic();
SchoolVan newSchoolVan = new SchoolVan();
logic.Add(newSchoolVan);
newSchoolVan.Id = logic.GetNextIdFree() - 1;
Route expectedRoute = new Route();
expectedRoute.TheSchoolVan = newSchoolVan;
Coordinate schoolCoordinate = new Coordinate();
expectedRoute.Add(schoolCoordinate);
expectedRoute.Add(newStudent);
List <Route> expectedRoutes = new List <Route>();
expectedRoutes.Add(expectedRoute);
List <Route> obtainRoutes = schoolVanLogic.GetBestRoutes();
Assert.IsTrue(obtainRoutes.SequenceEqual(expectedRoutes));
}
public IEnumerable <StudentsDetail> GetStudentById(int id)
{
List <StudentsDetail> studentsDetailList = new List <StudentsDetail>();
StudentLogic studentLogicBL = new StudentLogic();
return(studentLogicBL.GetStudentById(id));
}
public StudentC [] GetStudents()
{
try
{
StudentLogic sl = new StudentLogic();
DataTable dt = sl.GetStudent();
StudentC [] std = new StudentC[dt.Rows.Count];
int i = 0;
foreach (DataRow row in dt.Rows)
{
std[i] = new StudentC();
std[i].StudentId = Int32.Parse(row[0].ToString());
std[i].Name = row[1].ToString();
std[i].DOB = DateTime.Parse(row[2].ToString());
std[i].GPA = (double)Decimal.Parse(row[3].ToString());
std[i].Active = bool.Parse(row[4].ToString());
i++;
}
return(std);
}
catch (Exception exc)
{
throw exc;
}
}
public SearchOnTextBoxListCourse(CommonExchange.SysAccess userInfo, StudentLogic studentManager, String courseGroupId)
{
_userInfo = userInfo;
_studentManager = studentManager;
_courseGroupId = courseGroupId;
}
public IEnumerable <string> GetAllStudents()
{
StudentLogic studentLogic = new StudentLogic();
List <string> students = studentLogic.GetAllStudents();
return(students);
}
public StudentGuidanceUpdate(CommonExchange.SysAccess userInfo, CommonExchange.Student studentInfo, StudentLogic studentManager)
: base(userInfo)
{
this.InitializeComponent();
_userInfo = userInfo;
_studentInfo = studentInfo;
_studentInfo.ObjectState = System.Data.DataRowState.Modified;
_studentInfoTemp = (CommonExchange.Student)_studentInfo.Clone();
_studentManager = studentManager;
_errProvider = new ErrorProvider();
this.txtStudentOtherInformation.Validated += new EventHandler(txtStudentOtherInformationValidated);
this.FormClosing += new FormClosingEventHandler(ClassClosing);
this.chkForm138.CheckedChanged += new EventHandler(chkForm138CheckedChanged);
this.chkHonorableDismissal.CheckedChanged += new EventHandler(chkHonorableDismissalCheckedChanged);
this.chkTranscriptOfRecords.CheckedChanged += new EventHandler(chkTranscriptOfRecordsCheckedChanged);
this.chkGoodMoral.CheckedChanged += new EventHandler(chkGoodMoralCheckedChanged);
this.chkBirthCertificate.CheckedChanged += new EventHandler(chkBirthCertificateCheckedChanged);
this.chkMarriageContract.CheckedChanged += new EventHandler(chkMarriageContractCheckedChanged);
this.chkPhoto.CheckedChanged += new EventHandler(chkPhotoCheckedChanged);
this.chkNCAE.CheckedChanged += new EventHandler(chkNCAECheckedChanged);
this.btnClose.Click += new EventHandler(btnCloseClick);
this.btnUpdate.Click += new EventHandler(btnUpdateClick);
}
public StudyingStatusWindow(StudyingStatusLogic logicSS, StudentLogic logicS)
{
InitializeComponent();
this.logicSS = logicSS;
this.logicS = logicS;
logger = LogManager.GetCurrentClassLogger();
}
private bool IsCorrectDevice(STUDENT student)
{
try
{
StudentLogic studentLogic = new StudentLogic();
string hostname = Dns.GetHostName();
string ip = Dns.GetHostByName(hostname).AddressList[0].ToString();
if (student.Ip_Address == null)
{
student.Ip_Address = ip;
studentLogic.Modify(student);
return(true);
}
else
{
if (student.Ip_Address == ip)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public OrderWindow(OrderLogic logic, StudentLogic logicS)
{
InitializeComponent();
this.logic = logic;
this.logicS = logicS;
logger = LogManager.GetCurrentClassLogger();
}
public bool AddStudent(StudentModel sModel)
{
//TODO if user exist not insert
StudentLogic studentLogicBL = new StudentLogic();
StudentsDetail studentsDetailList = new StudentsDetail();
studentsDetailList.UserName = sModel.UserName;
//Encrypt Password
var keyNew = EncryptUtility.GeneratePassword(10);
var encryptPassword = EncryptUtility.EncodePassword(sModel.Password, keyNew);
studentsDetailList.Password = encryptPassword;
studentsDetailList.student_first_name = sModel.FirstName;
studentsDetailList.student_last_name = sModel.LastName;
studentsDetailList.student_middle_name = sModel.MiddleName;
studentsDetailList.student_address1 = sModel.Address_Line1;
studentsDetailList.student_city = sModel.City;
studentsDetailList.student_country = sModel.Country;
studentsDetailList.student_email = sModel.Email;
studentsDetailList.student_graduation_year = sModel.GraduationYear;
studentsDetailList.student_id = sModel.StudentId;
studentsDetailList.is_international_student = sModel.isInternationStudent;
studentsDetailList.date_created = DateTime.Now;
return(studentLogicBL.AddStudent(studentsDetailList));
//return false;
}
void StudentFunction()
{
MyDatabaseConnection studentData = new MyDatabaseConnection();
StudentLogic studentLogic = new StudentLogic();
Console.WriteLine("\t1. Add Students details. ");
Console.WriteLine("\t2. Get student detail by ID.");
Console.WriteLine("\t3. Exit.");
Console.Write("Enter Choice: ");
int Choice = Convert.ToInt32(Console.ReadLine());
switch (Choice)
{
case 1:
// call to GiveStudentDetail to enter student's details
Student student = studentLogic.GetStudentDetailsFromUser();
// call to AddStudent method to store entered details in Database
studentData.AddStudent(student);
break;
case 2:
// call to GetStudent method to fetch data from Database
studentData.GetStudent();
break;
case 3:
System.Environment.Exit(0);
break;
default:
Console.WriteLine("Please enter Correct choice!!!");
break;
}
}
public HttpResponseMessage AddStudents(int classId)
{
try
{
HttpResponseMessage response = new HttpResponseMessage();
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
foreach (string file in httpRequest.Files)
{
HttpPostedFile postedFile = httpRequest.Files[file];
//string filePath = HttpContext.Current.Server.MapPath("~/UploadFiles/" + postedFile.FileName);
//postedFile.SaveAs(filePath);
string extension = Path.GetExtension(postedFile.FileName);
if (!extension.Equals(".xlsx") && !extension.Equals(".xls"))
{
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.NotImplemented);
message.Content = new StringContent("file is not excel");
throw new HttpResponseException(message);
}
StudentLogic.AddStudents(postedFile, classId);
}
}
return(response);
}
catch (Exception ex)
{
return(null);
}
}
protected override void OnLoad(EventArgs e)
{
this.StudentField.DataSource = StudentLogic.GetAll();
this.StudentField.DataBind();
this.CourseField.DataSource = CourseLogic.GetAll();
this.CourseField.DataBind();
}
public StudentCourse(CommonExchange.SysAccess userInfo, CommonExchange.Student studentInfo, StudentLogic studentManager, String couseGroupId)
{
this.InitializeComponent();
_userInfo = userInfo;
_studentManager = studentManager;
_errProvider = new ErrorProvider();
_couseGroupId = couseGroupId;
_enrolmentCourseInfo = new CommonExchange.StudentEnrolmentCourse();
if (String.IsNullOrEmpty(studentInfo.StudentSysId))
{
_enrolmentCourseInfo.StudentInfo.StudentSysId = "SYSTMP " + studentInfo.StudentId;
}
else
{
_enrolmentCourseInfo.StudentInfo.StudentSysId = studentInfo.StudentSysId;
}
this.Load += new EventHandler(ClassLoad);
this.cboYear.SelectedIndexChanged += new EventHandler(cboYearSelectedIndexChanged);
this.cboSemester.SelectedIndexChanged += new EventHandler(cboSemesterSelectedIndexChanged);
this.btnSearchCourse.Click += new EventHandler(btnSearchCourseClick);
this.chkIsCurrentCourse.CheckedChanged += new EventHandler(chkIsCurrentCourseCheckedChanged);
}
//-------------------------------------------------------------------------------
protected void GridView14_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
try
{
((Label)e.Row.Cells[1].FindControl("Label36")).Text = StudentLogic.getClassForGPA(double.Parse(((Label)e.Row.Cells[1].FindControl("Label35")).Text));
}
catch (Exception er)
{
((Label)e.Row.Cells[1].FindControl("Label36")).Text = "TBD";
}
try
{
double val = double.Parse(((Label)e.Row.Cells[1].FindControl("Label35")).Text);
((Label)e.Row.Cells[1].FindControl("Label35")).Text = Math.Round(val, 2).ToString();
}
catch (Exception er)
{
((Label)e.Row.Cells[1].FindControl("Label35")).Text = "No GPA";
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[1].Text = DropDownList10.SelectedItem.Text;
e.Row.Cells[2].Text = DropDownList11.SelectedItem.Text;
}
}
public void GetFirstNextStudentId()
{
SetUp();
StudentLogic logic = new StudentLogic();
int expectedValue = 1;
Assert.IsTrue(logic.GetNextIdFree().Equals(expectedValue));
}
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string colour = StudentLogic.getCustomColour(float.Parse(((Label)e.Row.Cells[2].FindControl("Label13")).Text));
((TableCell)e.Row.Cells[2]).BackColor = System.Drawing.ColorTranslator.FromHtml(colour);
}
}
public async Task TestStudentWithEnrollment()
{
var repo = new StudentRepository(_context);
var logic = new StudentLogic(repo);
var student = await logic.TestStudentWithEnrollment();
Assert.NotNull(student.Enrollments);
}
public StudentCashierCreate(CommonExchange.SysAccess userInfo, StudentLogic studentManager, Boolean isForRegistrar)
: base(userInfo, studentManager, isForRegistrar)
{
this.InitializeComponent();
this.FormClosing += new FormClosingEventHandler(StudentCreateFormClosing);
this.btnCancel.Click += new EventHandler(btnCancelClick);
this.btnCreate.Click += new EventHandler(btnCreateClick);
}
public AttendanceController()
{
_studentLogic = new StudentLogic();
_eventLogic = new EventLogic();
_absentTypeLogic = new AbsentTypeLogic();
_attendanceLogic = new AttendanceLogic();
_absentLogLogic = new AbsentLogLogic();
_courseLogic = new CourseLogic();
}
public StudentEnrolmentHistory(CommonExchange.SysAccess userInfo, StudentLogic studentManager, CommonExchange.Student studentInfo, Boolean isForRegistrar)
: base(userInfo, studentManager, isForRegistrar)
{
this.InitializeComponent();
_studentInfo = studentInfo;
this.btnClose.Click += new EventHandler(btnCloseClick);
}
public void AddStudentSuccess()
{
SetUp();
StudentLogic testLogic = new StudentLogic();
Student newStudent = TestStudent();
testLogic.Add(newStudent);
Assert.IsTrue(testLogic.Exists(newStudent));
}
public void DeleteStudentSuccess()
{
SetUp();
StudentLogic testLogic = new StudentLogic();
Student newStudent = TestStudent();
testLogic.Add(newStudent);
testLogic.Remove(newStudent);
Assert.IsFalse(testLogic.Exists(newStudent));
}
public ClientMenuHandler(LogsLogic logs, Socket clientSocket, Socket notificationSocket, StudentLogic studentLogicHandler, CourseLogic courseLogicHandler, ref List <Utils.StudentSocket> pClients)
{
Protocol = new Protocol();
ClientSocket = clientSocket;
NotificationSocket = notificationSocket;
studentLogic = studentLogicHandler;
courseLogic = courseLogicHandler;
clients = pClients;
Logs = logs;
}
public IActionResult DeleteStudent(string id)
{
StudentLogic studentLogic = new StudentLogic(_context);
StudentViewModel svm = new StudentViewModel();
Student s = studentLogic.GetById(id);
svm.Student = s;
return(View("DeleteStudent", svm));
}
public StudentEntryLevelUpdate(CommonExchange.SysAccess userInfo, CommonExchange.StudentEnrolmentLevel enrolmentLevelInfo,
CommonExchange.StudentEnrolmentCourse enrolmentCourseInfo, StudentLogic studentManager)
{
this.InitializeComponent();
_userInfo = userInfo;
_studentManager = studentManager;
_enrolmentCourseInfo = enrolmentCourseInfo;
_enrolmentLevelInfo = enrolmentLevelInfo;
_enrolmentLevelInfoTemp = (CommonExchange.StudentEnrolmentLevel)enrolmentLevelInfo.Clone();
CommonExchange.CourseInformation courseInfo = _studentManager.GetSelectedCourse(_enrolmentCourseInfo.CourseInfo.CourseId);
this.lblSysIdCourse.Text = courseInfo.CourseId;
this.lblCourseTitle.Text = courseInfo.CourseTitle;
this.lblDepartmentName.Text = _studentManager.GetCourseDepartmentName(courseInfo.CourseId);
String semester = String.IsNullOrEmpty(_studentManager.GetSemesterDescription(_enrolmentCourseInfo.SemesterInfo.SemesterSysId)) ? String.Empty :
_studentManager.GetSemesterDescription(_enrolmentCourseInfo.SemesterInfo.SemesterSysId) + " ";
this.lblSchoolYearSemester.Text = semester +
_studentManager.GetYearDescriptionByFeeInformationSystemId(_enrolmentCourseInfo.SchoolFeeInfo.FeeInformationSysId);
this.lblSysID.Text = _enrolmentLevelInfo.EnrolmentLevelSysId;
this.chkIsEntryLevel.Checked = _enrolmentLevelInfo.IsEntryLevel;
this.chkIsEntryLevel.Enabled = false;
_studentManager.InitializeSchoolYearComboLevelUpdate(this.cboYear, _studentManager.GetYearIdByEnrolmentLevelSysId(_enrolmentLevelInfo.EnrolmentLevelSysId));
if (_studentManager.IsSemestralByCourse(_enrolmentCourseInfo.CourseInfo.CourseId))
{
_studentManager.InitializeSemesterComboUpdateLevel(this.cboSemester, _enrolmentLevelInfo.SemesterInfo.SemesterSysId);
_dateStart = _studentManager.GetSemesterDateStart(_enrolmentLevelInfo.SemesterInfo.SemesterSysId);
_dateEnd = _studentManager.GetSemesterDateEnd(_enrolmentLevelInfo.SemesterInfo.SemesterSysId);
}
else
{
_dateStart = _studentManager.GetSchoolYearDateStart(_studentManager.GetYearIdByEnrolmentLevelSysId(_enrolmentLevelInfo.EnrolmentLevelSysId));
_dateEnd = _studentManager.GetSchoolYearDateEnd(_studentManager.GetYearIdByEnrolmentLevelSysId(_enrolmentLevelInfo.EnrolmentLevelSysId));
}
_studentManager.InitializeYearLevelComboUpdate(this.cboYearLevel, _enrolmentLevelInfo.EnrolmentLevelSysId);
this.SetRecordLocked();
this.cboSemester.Enabled = _studentManager.IsSemestralByCourse(courseInfo.CourseId) ? true : false;
this.FormClosing += new FormClosingEventHandler(ClassClosing);
this.btnClose.Click += new EventHandler(btnCloseClick);
this.btnDelete.Click += new EventHandler(btnDeleteClick);
}
public void ModifyStudentModifyNonExistent()
{
SetUp();
StudentLogic testLogic = new StudentLogic();
Student newStudent = TestStudent();
Student anotherStudent = TestStudent();
anotherStudent.Id = 4;
testLogic.Modify(newStudent, anotherStudent);
Assert.IsFalse(testLogic.Exists(anotherStudent));
}
public StudentC GetStudent(int StudentId)
{
StudentC std = new StudentC();
try
{
StudentLogic sl = new StudentLogic();
Student stdc = sl.GetStudent(StudentId);
std.StudentId = stdc.StudentId;
std.Name = stdc.Name;
std.DOB = stdc.DOB;
std.GPA = stdc.GPA;
std.Active = stdc.Active;
}
catch (Exception exc)
{
throw exc;
}
return std;
}
public void AddStudent(StudentC []stdc)
{
try
{
StudentLogic sl = new StudentLogic();
Student[] std = new Student[stdc.Length];
for (int i = 0; i < stdc.Length; i++)
{
std[i] = new Student();
std[i].Name = stdc[i].Name;
std[i].DOB = stdc[i].DOB;
std[i].GPA = stdc[i].GPA;
std[i].Active = stdc[i].Active;
}
sl.AddStudent(std);
}
catch (Exception exc)
{
throw exc;
}
}
public StudentC[] GetStudents()
{
try
{
StudentLogic sl = new StudentLogic();
DataTable dt = sl.GetStudent();
StudentC [] std = new StudentC[dt.Rows.Count];
int i = 0;
foreach (DataRow row in dt.Rows)
{
std[i] = new StudentC();
std[i].StudentId = Int32.Parse( row[0].ToString());
std[i].Name = row[1].ToString();
std[i].DOB = DateTime.Parse( row[2].ToString());
std[i].GPA = (double)Decimal.Parse(row[3].ToString());
std[i].Active = bool.Parse( row[4].ToString());
i++;
}
return std;
}
catch (Exception exc)
{
throw exc;
}
}
