public void LoadRecipt() { var ExamRegistered = DropDownManager.GetRegistrationsById(lblID.Text); //DataTable dt = new DataTable(); //dt.Columns.Add("SN"); //dt.Columns.Add("Type"); //dt.Columns.Add("Student"); //dt.Columns.Add("Date"); //dt.Columns.Add("Amount"); foreach (var item in ExamRegistered) { lblInvoiceNo.Text = "234245453"; lblDate.Text = item.DateRegistered.ToLongDateString(); lblSchoolAddress.Text = item.School.Address; lblSchoolEmail.Text = item.School.Email; lblSchoolLGA.Text = item.School.LocalGovernment.LocalGovernment1; lblschoolName.Text = item.School.Name; int nostudent = int.Parse(noOfStudent.Text); var fee = int.Parse(item.Examination.Fee) * nostudent; lblDateFReg.Text = item.DateRegistered.ToLongDateString(); lblFeeAmount.Text = fee.ToString(); lblSubTotal.Text = fee.ToString(); lblFeesType.Text = lblExamCode1.Text; lblNoFStudent.Text = nostudent.ToString(); lblTotal.Text = Convert.ToDecimal(fee).ToString(); LoadBarcode(item.Examination.ExamCode + "" + item.StudentId + "" + item.SchoolId); return; } }
public void LoadAllStudent() { DataTable dt = new DataTable(); dt.Columns.Add("SN"); dt.Columns.Add("Name"); dt.Columns.Add("Sex"); dt.Columns.Add("Date"); dt.Columns.Add("School"); dt.Columns.Add("Status"); var student = DropDownManager.GetAllStudents(null); if (student != null) { int sn = 0; foreach (var item in student) { string status = GetStatus(item.StudentId); string Name = item.FirstName + "" + item.MiddleName + " " + item.LastName.ToString(); string sex = item.Sex.ToString(); string Date = item.DateOfBirth.ToString(); string school = item.School.Name; sn++; dt.Rows.Add(sn, Name, sex, Date, school, status); } gvStudents.DataSource = dt; gvStudents.DataBind(); } }
protected void tblGeneral_RowCommand(object sender, GridViewCommandEventArgs e) { int tempsessionId = GeneralUtility.GetCurrentSessionId(); string SessionId = ddlyear.SelectedValue.ToString(); string Lga = ddlLgda.SelectedValue.ToString(); string id = e.CommandArgument.ToString(); lblSchoolId.Text = id; if (e.CommandName.ToLower() == "doapprove") { string CountApproved = GeneralUtility.ApproveSchool(int.Parse(id), tempsessionId); int i = 0; if (int.TryParse(CountApproved, out i) && int.Parse(CountApproved) > 0) { DropDownManager.ShowPopUp("Operation Successful, " + CountApproved + " Records Approved"); return; } else { DropDownManager.ShowPopUp("Operation Not Successful, No Records Approved"); return; } } else if (e.CommandName.ToLower() == "doview") { LoadAllStudents(tempsessionId, int.Parse(id)); panelStudent.Visible = true; PnlSchool.Visible = false; } }
public void PopulateExam() { var userId = HttpContext.Current.User.Identity.GetUserId(); var school = DropDownManager.GetSchoolByUserId(userId); if (school != null) { lblSchoolId.Text = school.Id.ToString(); lblSchoolType.Text = school.SchoolTypeId.ToString(); lblSchoolCat.Text = school.CategoryId.ToString(); string catId = school.CategoryId.ToString(); var dt = new DataTable(); dt.Columns.Add("SN"); dt.Columns.Add("ID"); dt.Columns.Add("EXAM"); dt.Columns.Add("EXAMCODE"); dt.Columns.Add("FEE"); var Exams = DropDownManager.GetExaminations(catId); int sn = 0; foreach (var item in Exams) { string examId = item.ExamId.ToString(); string examName = item.Name.ToString(); string examCode = item.ExamCode.ToString(); string examFee = item.Fee.ToString(); string examStatus = item.Activated.ToString(); sn++; dt.Rows.Add(sn, examId, examName, examCode, examFee); } gvExam.DataSource = dt; gvExam.DataBind(); } }
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { if (ddlState.SelectedIndex > 0) { DropDownManager.GetLGA(ddlLGA, ddlState.SelectedValue.TrimEnd()); } }
public void PopulateExamDetails() { var dt = new DataTable(); dt.Columns.Add("SN"); dt.Columns.Add("NAME"); dt.Columns.Add("SCHOOL"); dt.Columns.Add("EXAMINATION"); dt.Columns.Add("FEES"); dt.Columns.Add("EXAMID"); var Exams = DropDownManager.GetRegisteredStudents(); int sn = 0; foreach (var item in Exams) { string id = item.StudentID.ToString(); string Name = item.StudentName; string schoolName = item.SchoolName; string Exam = item.ExamCode; string ExamId = item.ExamId.ToString() + "," + item.StudentID.ToString() + "," + item.SchoolId.ToString(); string Fee = item.Fee; sn++; dt.Rows.Add(sn, Name, schoolName, Exam, Fee, ExamId); } gvSubject.DataSource = dt; gvSubject.DataBind(); }
public void LoadAllStudent() { DataTable dt = new DataTable(); dt.Columns.Add("SN"); dt.Columns.Add("ID"); dt.Columns.Add("Name"); dt.Columns.Add("Sex"); dt.Columns.Add("Date"); dt.Columns.Add("School"); dt.Columns.Add("Status"); var student = DropDownManager.GetAllStudents(null); if (student != null) { int sn = 0; foreach (var item in student) { string id = item.StudentId.ToString(); string status = GetStatus(item.StudentId); string Name = item.FirstName + " " + item.MiddleName + " " + item.LastName.ToString(); string sex = item.Sex.ToString(); string Date = item.DateCreated ?? DateTime.Now.ToLongDateString(); string school = item.School.Name; sn++; dt.Rows.Add(sn, id, Name, sex, Date, school, status); } gvStudents.DataSource = dt; gvStudents.DataBind(); gvStudents.HeaderRow.TableSection = TableRowSection.TableHeader; } }
protected void btnSecEntryReject_Click(object sender, EventArgs e) { if (inspectorServices.ApproveOrRejectSchedule(false, SessionUser.SchoolId, ddlExam1.SelectedValue, ddlYear1.SelectedValue)) { DropDownManager.ShowPopUp("Approved Successfully !!!"); //PopulateAttendancePri(SessionUser.SchoolId.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownManager.PopulateExam(ddlExam, SessionUser.CategoryId); DropDownManager.PopulateYear(ddlYear); } }
//DropDownManager dropDownManager = new DropDownManager(); //public LgaInspector(InspectorServices inspectorServicesParam) //{ // inspectorServices = inspectorServicesParam; //} protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownManager.GetTitle(ddlTitle); loadTable(); } }
protected void btnAttendApprove_Click(object sender, EventArgs e) { if (inspectorServices.ApproveOrRejectAttendance(true, SessionUser.SchoolId, ddlExam.SelectedValue, ddlSubject.SelectedValue, ddlYear.SelectedValue)) { DropDownManager.ShowPopUp("Approved Successfully !!!"); PopulateAttendancePri(SessionUser.SchoolId.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownManager.PopulateYear(ddlYear); DropDownManager.PopulateSchool(ddlSchool); DropDownManager.GetLGA(ddlLocalGovt, "ED"); } }
protected void Page_Load(object sender, EventArgs e) { if (SessionUser == null) { Response.Redirect("~/Account/Login"); } DropDownManager.PopulateExam(ddlExam, SessionUser.CategoryId); DropDownManager.PopulateYear(ddlYear); }
private DataTable GetTableForExecl() { DataTable table = new DataTable(); table.Columns.Add("StudentID"); table.Columns.Add("SN"); table.Columns.Add("NAME OF CANDIDATE"); table.Columns.Add("Exam NO"); table.Columns.Add("Subject"); table.Columns.Add("Present"); table.Columns.Add("Mark"); table.Columns.Add("Remarks"); table.Columns.Add("ExaminationID"); table.Columns.Add("Examination"); table.Columns.Add("SessionID"); table.Columns.Add("Session"); table.Columns.Add("SchoolId"); table.Columns.Add("SubjectId"); int exam = int.Parse(ddlExam.SelectedValue.ToString()); int session = int.Parse(ddlYear.SelectedValue.ToString()); string subject = ddlSubject.SelectedValue.ToString(); //string userId = string.Empty; //try //{ // userId = User.Identity.GetUserId(); //} //catch (Exception ex) //{ // Response.Redirect("~/Account/Login"); //} //Models.School school = dropManager.GetSchoolByUserId(userId); var registration = DropDownManager.GetRegistrations(SessionUser.SchoolId, session, exam, subject); if (registration.Count() > 0 && registration != null) { int counter = 1; foreach (var item in registration) { int studentId = item.StudentId; string name = $"{item.Student.LastName} {item.Student.FirstName} {item.Student.MiddleName ?? ""}"; string examNum = item.StudentRegNum ?? $"{item.Examination.ExamCode}00{counter} "; string attendance = item.Attendance?.ToString(); string mark = item.TotalScore.ToString() ?? ""; string subjectName = item.Subject.Name; string remark = item.AttendanceRemarks ?? ""; string examName = item.Examination.Name; string examId = item.ExamId.ToString(); int sessionId = item.SessionId.Value; string year = item.Session.Name; table.Rows.Add(studentId, counter, name, examNum, subjectName, attendance, mark, remark, examId, examName, sessionId, session, SessionUser.SchoolId, item.SubjectId); counter++; } } return(table); }
//DropDownManager dropDownManager = new DropDownManager(); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DropDownManager.PopulateRelation(ddlRelation); DropDownManager.GetLGA(ddlLGA, null); DropDownManager.GetState(ddlState); DropDownManager.GetGender(ddlSex); } }
private void createDropDownForErrorType() { DropDownManager dropDownManager = new DropDownManager(); ViewBag.Machine = dropDownManager.getErrorTypeForD5DropDown("Machine"); ViewBag.Method = dropDownManager.getErrorTypeForD5DropDown("Method"); ViewBag.Men = dropDownManager.getErrorTypeForD5DropDown("Men"); ViewBag.Material = dropDownManager.getErrorTypeForD5DropDown("Material"); ViewBag.Monde = dropDownManager.getErrorTypeForD5DropDown("Monde"); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (ValidateInputs()) { var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>(); var signInManager = Context.GetOwinContext().Get <ApplicationSignInManager>(); var user = new ApplicationUser() { UserName = txtEmail.Value, Email = txtEmail.Value, PhoneNumber = txtMobileNo.Value }; IdentityResult result = manager.Create(user, "@1234567"); if (result.Succeeded) { // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 //string code = manager.GenerateEmailConfirmationToken(user.Id); //string callbackUrl = IdentityHelper.GetUserConfirmationRedirectUrl(code, user.Id, Request); manager.AddToRole(user.Id, "School"); //manager.SendEmail(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>."); int selectedRadio = 0; if (radPublic.Checked == true) { selectedRadio = int.Parse(radPublic.Value); } else { selectedRadio = int.Parse(radPrivate.Value); } var school = new Models.School() { Name = txtname.Value, Address = txtAddress.Value, Email = txtEmail.Value, MobileNo = Convert.ToDecimal(txtMobileNo.Value), NameOfPrincipal = ddlTitle.SelectedItem.Text + " " + txtPrincipal.Value, DateOfIncorporation = Convert.ToDateTime(txtdate.Value), SchoolTypeId = selectedRadio, CategoryId = int.Parse(ddlSchoolCat.SelectedValue), LocalGovernmentID = int.Parse(ddlLGA.SelectedValue), UserId = user.Id, CreatedBy = "", DateCreated = DateTime.Now }; unitOfWork.School.Insert(school); unitOfWork.Save(); //signInManager.SignIn(user, isPersistent: false, rememberBrowser: false); DropDownManager.ShowPopUp("School Added Successfully !!!"); //IdentityHelper.RedirectToReturnUrl("Registration/School", Response); ClearInput(); } else { ErrorMessage.Text = result.Errors.FirstOrDefault(); } } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = "Add New School"; if (!Page.IsPostBack) { DropDownManager.GetLGA(ddlLGA, "ED"); DropDownManager.GetCategory(ddlSchoolCat); DropDownManager.GetTitle(ddlTitle); ddlLGA.SelectedValue = SessionUser.LgaId.ToString(); } }
public BookViewModel BookDropdowns(int id = 0) { DropDownManager ddManager = new DropDownManager(); BookViewModel bookView = new BookViewModel(); bookView.ListOfFloors = ddManager.FloorDropdown(); bookView.ListOfOffices = ddManager.OfficeDropDown(); bookView.ListOfWorkpoint = ddManager.WorkpointsDropdown(); bookView.ListOfUsers = ddManager.UsersDropdown(); return(bookView); }
protected void gvExam_RowCommand(object sender, GridViewCommandEventArgs e) { string id = e.CommandArgument.ToString(); string[] Ids = id.Split(','); string ExamId = Ids[0]; string StudentId = Ids[1]; string schoolId = Ids[2]; DropDownManager.ShowPopUp(ExamId + " " + StudentId + " " + schoolId); }
protected void btnAttendenceList_Click(object sender, EventArgs e) { try { string filename = "Attendance For -" + lblExamName.Text; DropDownManager.GenerateExcel(GetTableForExecl(), filename, "Attendance", Response); } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
protected void btnPriEntry_Click(object sender, EventArgs e) { try { string filename = "Entry Schedule For-" + lblExamName.Text; DropDownManager.GenerateExcel(BuildTableForExcelPrimary(), filename, "Pri_Entry", Response); } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (SessionUser.SchoolType == 1) { var result = GeneralUtility.HasSchoolBeenAssignedQuota(SessionUser.SchoolId); if (!result) { DropDownManager.ShowPopUp("Quota Has not been Assigned For this Year"); return; } } }
protected void btnUpload_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(xlsxSchol.PostedFile.FileName)) { DataTable table = new DataTable(); table.Columns.Add("ID"); table.Columns.Add("SN"); table.Columns.Add("REG_NUM"); table.Columns.Add("FULLNAME"); table.Columns.Add("DATE_OF_BIRTH"); table.Columns.Add("GENDER"); table.Columns.Add("EXAM_YEAR"); table.Columns.Add("ADDRESS"); table.Columns.Add("PICTURES"); lblFileName.Text = GeneralUtility.GetExcelFile(xlsxSchol); string extenstion = Path.GetExtension(lblFileName.Text); if (extenstion != ".xml") { DataSet ds = new DataSet(); ds.ReadXml(lblFileName.Text); int counter = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string ID = ds.Tables[0].Rows[i]["ID"].ToString(); string RegNum = ds.Tables[0].Rows[i]["REG_NUMBER"].ToString(); string LastName = ds.Tables[0].Rows[i]["SURNAME"].ToString(); string FirstName = ds.Tables[0].Rows[i]["LASTNAME"].ToString(); string OtherName = ds.Tables[0].Rows[i]["OTHERNAME"].ToString(); string FullName = ds.Tables[0].Rows[i]["FULLNAME"].ToString(); string DateofBirth = ds.Tables[0].Rows[i]["DATE_OF_BIRTH"].ToString(); string Gender = ds.Tables[0].Rows[i]["GENDER"].ToString(); string ExamYear = ds.Tables[0].Rows[i]["EXAM_YEAR"].ToString(); string Address = ds.Tables[0].Rows[i]["ADDRESS"].ToString(); string Base64Picture = $"data:image/png;base64,{ ds.Tables[0].Rows[i]["PICTURE"].ToString()}"; // SponosorId = int.Parse(ds.Tables[0].Rows[i]["SPONOSORID"].ToString()) Base64Picture = $"<img src=\"{Base64Picture}\">"; ++counter; table.Rows.Add(ID, counter, RegNum, FullName, DateofBirth, Gender, ExamYear, Address, Base64Picture); } gvResults.DataSource = table; gvResults.DataBind(); excelDiv.Visible = true; gvResults.HeaderRow.TableSection = TableRowSection.TableHeader; } } else { DropDownManager.ShowPopUp("Please Upload a file"); } }
public string GetStatus(int studentId) { bool isRegistered = DropDownManager.IsStudentRegistered(studentId); if (isRegistered == true) { return("Registered"); } else { return("Not Registered"); } }
public bool ApproveOrRejectSchedule(bool status, int schoolId, string examId, string session) { int exam = 0; int sessionId = 0; int.TryParse(session, out sessionId); int.TryParse(examId, out exam); var registeredExam = DropDownManager.GetRegistrations(schoolId, sessionId, exam).FirstOrDefault(); registeredExam.EntyScheduleApprovedByInspector = status; unitOfWork.ExamRegistered.Update(registeredExam); unitOfWork.Save(); return(true); }
public void LoadSchool(string id) { if (id != null) { var school = DropDownManager.GetSchool(id); lblEmail.Text = school.Email; lblDate.Text = school.DateOfIncorporation.ToLongDateString(); lblPrincipal.Text = school.NameOfPrincipal; lblStudent.Text = statManager.GetStudentCount(int.Parse(id)); lblLga.Text = school.LocalGovernment.LocalGovernment1; lblDate1.Text = school.DateOfIncorporation.Year.ToString(); lblDate2.Text = school.DateOfIncorporation.ToLongDateString(); } }
public string GetSchoolId() { string userId = HttpContext.Current.User.Identity.GetUserId(); if (userId != null) { var schoolId = DropDownManager.GetSchoolId(userId); return(schoolId.ToString()); } else { var schoolId = 1; //dropDownManager.GetSchoolId(null); return(schoolId.ToString()); } }
public DataTable BuildTableForExcelSecondary() { DataTable table = new DataTable(); table.Columns.Add("StudentID"); table.Columns.Add("SN"); table.Columns.Add("Name Of Student"); table.Columns.Add("Exam NO"); table.Columns.Add("Sex"); table.Columns.Add("ENG. STUDIES"); table.Columns.Add("MATHS"); table.Columns.Add("BASIC SCIENCE & TECHNOLOGY"); table.Columns.Add("RELIGION & NATIONAL VALUES"); table.Columns.Add("CULTURAL & CREATIVE ARTS"); table.Columns.Add("NIGERIA LANGUAGE(EDO)"); table.Columns.Add("PRE-VOCATIONAL"); table.Columns.Add("FRENCH LANGUAGE"); table.Columns.Add("BUSINESS STUDIES"); table.Columns.Add("ARABIC"); table.Columns.Add("PRATICAL 5MRKS"); table.Columns.Add("NO OF SUBJECTS ENTERED FOR"); table.Columns.Add("STUDENTS SIGNATURE"); table.Columns.Add("REMARKS"); table.Columns.Add("ExaminationID"); table.Columns.Add("SessionID"); table.Columns.Add("SchoolId"); int exam = int.Parse(ddlExam.SelectedValue.ToString()); int session = int.Parse(ddlYear.SelectedValue.ToString()); string userId = string.Empty; var registration = DropDownManager.GetRegistrations(SessionUser.SchoolId, session, exam); if (registration.Count() > 0 && registration != null) { int counter = 1; foreach (var item in registration) { int studentId = item.StudentId; string name = $"{item.Student.LastName} {item.Student.FirstName} {item.Student.MiddleName ?? ""}"; string examNum = item.StudentRegNum ?? $"{item.Examination.ExamCode}00{counter} "; string sex = item.Student.Sex; table.Rows.Add(studentId, counter, name, examNum, sex, "", "", "", "", "", "", "", "", "", "", "", "", "", "", item.ExamId, item.SessionId, SessionUser.SchoolId); } } return(table); }
public void LoadAllStudent() { DataTable dt = new DataTable(); dt.Columns.Add("SN"); dt.Columns.Add("ID"); dt.Columns.Add("Name"); dt.Columns.Add("Email"); dt.Columns.Add("Address"); dt.Columns.Add("students"); dt.Columns.Add("Status"); var student = DropDownManager.GetAllSchools(); if (student != null) { int sn = 0; foreach (var item in student) { string id = item.Id.ToString(); string status = GetStatus(item.Id); string Name = item.Name; string Email = item.Email.ToString(); string students = stat.GetStudentCount(item.Id); string Address = item.Address; sn++; dt.Rows.Add(sn, id, Name, Email, Address, students, status); } gvSchools.DataSource = dt; gvSchools.DataBind(); foreach (GridViewRow row in gvSchools.Rows) { Label lblStatus = (Label)row.FindControl("lblStatus"); if (lblStatus.Text == "Registered") { lblStatus.CssClass = "btn btn-success"; } else { lblStatus.CssClass = "btn btn-danger"; } } } }