public string UpdateSessionSemester(SessionSemester sem) { using (var context = new BASContext()) { var oldSem = context.SessionSemesters.SingleOrDefault(a => a.Id == sem.Id && !a.IsDeleted); if (oldSem == null) { return("Session Semester not found"); } if (context.SessionSemesters.Any(a => a.Session == sem.Session && a.Semester == sem.Semester && !a.IsDeleted && a.Id != sem.Id)) { return("Session Semester already exist"); } oldSem.Session = sem.Session; oldSem.Semester = sem.Semester; oldSem.IsActive = sem.IsActive; if (sem.IsActive) { var allsems = context.SessionSemesters.Where(a => !a.IsDeleted); foreach (var item in allsems) { item.IsActive = false; } } if (context.SaveChanges() > 0) { return("Session Semester details updated successfully"); } return("Session Semester details could not be updated"); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (PassedValidation()) { var model = new SessionSemester() { Session = txtSession.Text.ToTitleCase(), Semester = txtSemester.Text.ToTitleCase(), IsActive = chkIsActive.Checked }; if (model.IsActive) { DialogResult result1 = MessageBox.Show( "Are you sure you want to make this the active session/semester?", "Confirm Active", MessageBoxButtons.YesNo); if (result1 == DialogResult.Yes) { PerformSave(model); } } else { PerformSave(model); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error occured", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public string AddSessionSemester(SessionSemester newSem) { try { using (var context = new BASContext()) { if (context.SessionSemesters.Any(a => a.Session == newSem.Session && a.Semester == newSem.Semester && !a.IsDeleted)) { return("Session and Semester already exist"); } if (newSem.IsActive) { var allsems = context.SessionSemesters.Where(a => !a.IsDeleted); foreach (var item in allsems) { item.IsActive = false; } } context.SessionSemesters.Add(newSem); if (context.SaveChanges() > 0) { return("Session Semester added successfully"); } return("Session Semester could not be added"); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { if (!LoggedInUser.IsAdmin) { Base.ShowError("Access Denied", "You do not have the required permission"); return; } var item = new SessionSemester() { Id = _id, Session = txtSession.Text.ToTitleCase(), Semester = txtSemester.Text.ToTitleCase(), IsActive = checkActive.Checked }; var validate = ValidateForm(); if (validate == string.Empty) { AddOrUpdate(item); } else { Base.ShowInfo("Validation Failed", validate); } }
private void FrmAttendance_Load(object sender, EventArgs e) { try { activeSemester = _semesterRepo.GetActiveSessionSemester(); if (activeSemester == null) { MessageBox.Show("You cannot mark attendance because there is no active semester", "Denied", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } lblSession.Text = activeSemester.Session + " - " + activeSemester.Semester; Cursor = Cursors.WaitCursor; // set culture Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB", false); Capturer = new DPFP.Capture.Capture(); // Create a capture operation. try { if ((Capturer != null)) { Capturer.StartCapture(); Capturer.EventHandler = this; } // Subscribe for capturing events. else { throw new Exception("Can't initiate capture operation! Please exit and relaunch the application"); } } catch (Exception ex) { logger.WriteLog(ex); MessageBox.Show("Can't initiate capture operation! Please exit and relaunch the application", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } Enroller = new DPFP.Processing.Enrollment(); Verificator = new DPFP.Verification.Verification(); Application.DoEvents(); Capturer.StartCapture(); SetPrompt("Using the fingerprint reader, scan your fingerprint."); } catch (Exception ex) { logger.WriteLog(ex); //MsgBox(ex.Message, MsgBoxStyle.Exclamation, Application.ProductName); } finally { Cursor = Cursors.Default; } getTodayAttendance(); }
public SessionSemesterForm(SessionSemester data = null) { InitializeComponent(); _semesterRepo = new SessionSemesterRepo(); if (data != null) { lblId.Text = data.Id.ToString(); txtSession.Text = data.Session; txtSemester.Text = data.Semester; chkIsActive.Checked = data.IsActive; lblTitle.Text = "Update Session/Semester"; } }
public string AddSessionSemester(SessionSemester newSem) { try { if (_context.SessionSemesters.Any(a => a.Session == newSem.Session && a.Semester == newSem.Semester && !a.IsDeleted)) { return("Session and Semester already exist"); } if (newSem.IsActive) { var allsems = _context.SessionSemesters.Where(a => !a.IsDeleted).ToList(); foreach (var item in allsems) { item.IsActive = false; } } newSem.Id = Guid.NewGuid().ToString(); _context.SessionSemesters.Add(newSem); if (_context.SaveChanges() > 0) { if (newSem.IsActive) //change the active semester on local sqlite { LoggedInUser.ActiveSession = newSem; var localSems = _localContext.SessionSemesters.Where(a => !a.IsDeleted).ToList(); foreach (var item in localSems) { item.IsActive = false; } _localContext.SaveChanges(); } return(""); } else { return("Session/Semester could not be added"); } } catch (Exception ex) { throw ex; } }
public string UpdateSessionSemester(SessionSemester sem) { var oldSem = _context.SessionSemesters.SingleOrDefault(a => a.Id == sem.Id && !a.IsDeleted); if (oldSem == null) { return("Session Semester not found"); } if (_context.SessionSemesters.Any(a => a.Session == sem.Session && a.Semester == sem.Semester && !a.IsDeleted && a.Id != sem.Id)) { return("Session Semester already exist"); } oldSem.Session = sem.Session; oldSem.Semester = sem.Semester; oldSem.IsActive = sem.IsActive; if (sem.IsActive) { var allsems = _context.SessionSemesters.Where(a => !a.IsDeleted && a.Id != oldSem.Id).ToList(); foreach (var item in allsems) { item.IsActive = false; } } if (_context.SaveChanges() > 0) { if (sem.IsActive) //change the active semester on local sqlite { LoggedInUser.ActiveSession = sem; var localSems = _localContext.SessionSemesters.Where(a => !a.IsDeleted && a.Id != oldSem.Id).ToList(); foreach (var item in localSems) { item.IsActive = false; } _localContext.SaveChanges(); } return(""); } else { return("Session/Semester could not be updated"); } }
private void AddOrUpdate(SessionSemester item) { var saveItem = _id == "" ? _repo.AddSessionSemester(item) : _repo.UpdateSessionSemester(item); if (saveItem == string.Empty) { Base.ShowSuccess("Success", "Session/Semester saved successfully"); this.Close(); } else { Base.ShowError("Failed", saveItem); } }
private void PerformSave(SessionSemester model) { string response; if (lblId.Text == string.Empty) //add { response = _semesterRepo.AddSessionSemester(model); if (response == string.Empty) { MessageBox.Show(this, "Session/Semester added successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearControls(); this.Hide(); } else { MessageBox.Show(this, response, "Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else //update { model.Id = int.Parse(lblId.Text); response = _semesterRepo.UpdateSessionSemester(model); if (response == string.Empty) { MessageBox.Show(this, "Session/Semester updated successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearControls(); this.Hide(); } else { MessageBox.Show(this, response, "Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }