public void saveEmployee(EmployeeEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblEmployee emp = new EDMX.tblEmployee
{
Id = obj.EmployeeId,
LastName = obj.LastName,
FirstName = obj.FirstName,
MiddleName = obj.MiddleName,
Active = obj.Active,
DateCreated = obj.DateCreated,
DateUpdated = obj.DateUpdated
};
db.tblEmployees.Add(emp);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Save Employee");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void savePatient(PatientEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblPatient pat = new EDMX.tblPatient
{
Id = obj.PatientId,
LastName = obj.LastName,
FirstName = obj.FirstName,
MiddleName = obj.MiddleName,
FacilityID = obj.FacilityId,
Active = obj.Active,
DateCreated = obj.DateCreated,
DateUpdated = obj.DateUpdated
};
db.tblPatients.Add(pat);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Save Patient");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//remove
//Save
//Update
public void getPatientMedication(int patID)
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var patMed = db.tblPatientMedicationLists.Where(x => x.PatientID == patID).Select(y => new
{
patientId = y.PatientID,
facilityName = y.tblPatient.tblFacility.Name,
patientName = y.tblPatient.LastName + ", " + y.tblPatient.FirstName,
medicationName = y.MedicationName,
dosage = y.Dosage,
direction = y.Direction,
orderedBy = y.OrderedBy,
startDate = y.StartDate,
endDate = y.EndDate,
durationType = y.DurationType,
note = y.Note,
id = y.Id
}).ToList();
dgvPatientMedication.DataSource = patMed;
}
}
public List <PatientEntity> searchPatientByLastName(string LastName)
{
List <PatientEntity> List = new List <PatientEntity>();
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
List = db.tblPatients.Where(x => x.LastName.Contains(LastName)).Select(x => new PatientEntity
{
PatientId = x.Id,
FacilityId = x.FacilityID,
FacilityName = x.tblFacility.Name,
LastName = x.LastName,
FirstName = x.FirstName,
MiddleName = x.MiddleName,
Active = x.Active,
DateCreated = x.DateCreated,
DateUpdated = x.DateUpdated
}).ToList();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Patient By Last Name");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(List);
}
public void updatePatientMedication(int medId)
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblPatientMedicationList patMed = db.tblPatientMedicationLists.Where(x => x.Id == medId).FirstOrDefault();
patMed.MedicationName = txtMedicationName.Text;
patMed.Dosage = txtDosage.Text;
patMed.Direction = txtDirection.Text;
patMed.OrderedBy = txtOrderedBy.Text;
patMed.StartDate = lblStartDate.Text;
patMed.EndDate = lblEndDate.Text;
if (rdNumOfDays.Checked == true)
{
patMed.DurationType = "N";
}
else if (rdDaily.Checked == true)
{
patMed.DurationType = "D";
}
else if (rdStop.Checked == true)
{
patMed.DurationType = "S";
}
patMed.Note = txtNotes.Text;
db.SaveChanges();
}
}
public void getAllFacility()
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var fac = db.tblFacilities.Where(x => x.Active == "Y").Select(y => new {
Id = y.Id,
Name = y.Name
});
int ctr = 0;
foreach (var res in fac)
{
_FacilityIDHolder.Add(res.Id);
cboFacility.Items.Add(res.Name);
ctr++;
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get All Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public EmployeeEntity searchEmployeeByID(int empID)
{
EmployeeEntity obj = new EmployeeEntity();
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblEmployee emp = db.tblEmployees.FirstOrDefault(x => x.Id == empID);
if (emp != null)
{
obj.EmployeeId = emp.Id;
obj.LastName = emp.LastName;
obj.FirstName = emp.FirstName;
obj.MiddleName = emp.MiddleName;
obj.Active = emp.Active;
obj.DateCreated = emp.DateCreated;
obj.DateUpdated = emp.DateUpdated;
}
else
{
obj = null;
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Employee By ID");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
obj = null;
}
return(obj);
}
public void saveFacility(FacilityEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblFacility fac = new EDMX.tblFacility
{
Id = obj.FacilityId,
Name = obj.Name,
Address = obj.Address,
Active = obj.Active,
DateCreated = obj.DateCreated,
DateUpdated = obj.DateUpdated
};
db.tblFacilities.Add(fac);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Save Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getAllFacility()
{
try
{
List <FacilityEntity> List = new List <FacilityEntity>();
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
List = db.tblFacilities.Select(x => new FacilityEntity
{
FacilityId = x.Id,
Name = x.Name,
Address = x.Address,
Active = x.Active,
DateCreated = x.DateCreated,
DateUpdated = x.DateUpdated
}).ToList();
}
dgvFacility.DataSource = List;
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get All Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getAllPatient()
{
try
{
List <PatientEntity> List = new List <PatientEntity>();
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
List = db.tblPatients.Select(x => new PatientEntity
{
PatientId = x.Id,
FacilityId = x.FacilityID,
FacilityName = x.tblFacility.Name,
LastName = x.LastName,
FirstName = x.FirstName,
MiddleName = x.MiddleName,
Active = x.Active,
DateCreated = x.DateCreated,
DateUpdated = x.DateUpdated
}).ToList();
}
dgvPatient.DataSource = List;
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get All Patient");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void savePatientMedication()
{
string durationType = "";
if (rdNumOfDays.Checked == true)
{
durationType = "N";
}
else if (rdDaily.Checked == true)
{
durationType = "D";
}
else if (rdStop.Checked == true)
{
durationType = "S";
}
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblPatientMedicationList patMed = new EDMX.tblPatientMedicationList
{
PatientID = Convert.ToInt32(lblPatientId.Text),
MedicationName = txtMedicationName.Text,
Dosage = txtDosage.Text,
Direction = txtDirection.Text,
OrderedBy = txtOrderedBy.Text,
StartDate = lblStartDate.Text,
EndDate = lblEndDate.Text,
DurationType = durationType,
Note = txtNotes.Text
};
db.tblPatientMedicationLists.Add(patMed);
db.SaveChanges();
}
}
public bool checkConflict(string Date, int EmployeeID)
{
bool res = false;
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
int emp = db.tblSchedules.Where(x => x.Date == Date && x.EmployeeID == EmployeeID).Count();
if (emp == 0)
{
res = false;
}
else
{
res = true;
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Check Conflict");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
res = true;
}
return(res);
}
public void deletePatientMedication(int medId)
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var patMed = db.tblPatientMedicationLists.Where(x => x.Id == medId).FirstOrDefault();
db.tblPatientMedicationLists.Remove(patMed);
db.SaveChanges();
MessageBox.Show("Successfully removed medication", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void searchEmployeeByLastName(string LastName)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var emp = db.tblEmployees.Where(x => x.LastName.Contains(LastName) && x.Active == "Y").Select(y => new {
EmployeeID = y.Id,
EmployeeName = y.LastName + ", " + y.FirstName + " " + y.MiddleName
}).ToList();
dgvEmployee.DataSource = emp;
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Employee By Last Name");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getMedicationList(int id, string patientName, string facilityName)
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var res = db.tblPatientMedicationLists.Where(y => y.PatientID == id).Select(x => new {
Id = x.Id,
PatientId = x.PatientID,
MedicationName = x.MedicationName.ToUpper(),
Dosage = x.Dosage.ToUpper(),
Direction = x.Direction.ToUpper(),
OrderedBy = x.OrderedBy.ToUpper(),
StartDate = x.StartDate.ToUpper(),
EndDate = x.EndDate.ToUpper(),
DurationType = x.DurationType.ToUpper(),
Note = x.Note.ToUpper(),
PatientName = patientName.ToUpper(),
FacilityName = facilityName.ToUpper()
}).ToList();
if (res.Count == 0)
{
res = db.tblPatients.Where(y => y.Id == id).Select(x => new {
Id = x.Id,
PatientId = 0,
MedicationName = "",
Dosage = "",
Direction = "",
OrderedBy = "",
StartDate = "",
EndDate = "",
DurationType = "",
Note = "",
PatientName = patientName.ToUpper(),
FacilityName = facilityName.ToUpper()
}).ToList();
}
ViewPatientMedicationListBindingSource.DataSource = res;
this.reportViewer1.RefreshReport();
}
}
public string getConflict(string Date, int FacilityID, int EmployeeID)
{
string conflict = "";
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var emp = db.tblSchedules.FirstOrDefault(x => x.Date == Date && x.EmployeeID == EmployeeID);
conflict = "Cant add this employee because of conflict in schedule" + "\n" +
emp.tblEmployee.LastName + ", " + emp.tblEmployee.FirstName + " " + emp.tblEmployee.MiddleName +
" already have schedule on " + emp.Date + " in " + emp.tblFacility.Name;
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get Conflict");
conflict = "Error Detected Please Contact Developer";
}
return(conflict);
}
public void updateFacility(FacilityEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblFacility emp = db.tblFacilities.Where(x => x.Id == obj.FacilityId).FirstOrDefault();
emp.Name = obj.Name;
emp.Address = obj.Address;
emp.Active = obj.Active;
emp.DateCreated = obj.DateCreated;
emp.DateUpdated = obj.DateUpdated;
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Update Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getAllFacility()
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var res = db.tblFacilities.Where(x => x.Active == "Y").ToList();
foreach (var a in res)
{
_facilityID.Add(a.Id);
cboFacility.Items.Add(a.Name);
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get All Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void searchPatientByID(int patID)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var pat = db.tblPatients.Where(x => x.Id == patID && x.Active == "Y").Select(y => new {
PatientID = y.Id,
FacilityName = y.tblFacility.Name,
PatientName = y.LastName + ", " + y.FirstName + " " + y.MiddleName
}).ToList();
dgvPatient.DataSource = pat;
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Employee By ID");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getStaffSchedule(int employeeID, string withPast)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var res = db.tblSchedules.Where(z => z.EmployeeID == employeeID).Select(x => new ViewScheduleByFacilityAndStaff
{
Date = x.Date,
EmployeeName = x.tblEmployee.LastName.ToUpper() + ", " + x.tblEmployee.FirstName.ToUpper() + " " + x.tblEmployee.MiddleName.ToUpper(),
Facility = x.tblFacility.Name.ToUpper(),
Address = x.tblFacility.Address.ToUpper()
}).ToList();
List <ViewScheduleByFacilityAndStaff> empSched = new List <ViewScheduleByFacilityAndStaff>();
if (withPast == "Y")
{
empSched = res;
}
else
{
foreach (var a in res)
{
if (Convert.ToDateTime(a.Date) >= Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
empSched.Add(a);
}
}
}
ViewScheduleByFacilityAndStaffBindingSource.DataSource = empSched;
this.rptViewByStaff.RefreshReport();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get Staff Schedule");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void removeEmployeeFromSchedule(string Date, int FacilityID, int EmployeeID)
{
try
{
DialogResult result = MessageBox.Show("Are you sure you want to remove this employee from the schedule?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var emp = db.tblSchedules.Where(x => x.Date == Date && x.FacilityID == FacilityID && x.EmployeeID == EmployeeID).FirstOrDefault();
db.tblSchedules.Remove(emp);
db.SaveChanges();
MessageBox.Show("Successfuly Removed from the schedule!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Remove from Schedule");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getScheduledEmployee(string Date, int FacilityID)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var scheduledEmp = db.tblSchedules.Where(x => x.Date == Date && x.FacilityID == FacilityID).Select(y => new {
Date = y.Date,
FacilityID = y.FacilityID,
FacilityName = y.tblFacility.Name,
EmployeeID = y.EmployeeID,
employeeName = y.tblEmployee.LastName + ", " + y.tblEmployee.FirstName + " " + y.tblEmployee.MiddleName
}).ToList();
dgvScheduledStaff.DataSource = scheduledEmp;
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get Scheduled Employee");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void addEmployeeToSchedule(string Date, int FacilityID, int EmployeeID)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblSchedule sched = new EDMX.tblSchedule
{
Id = 1,
Date = Date,
FacilityID = FacilityID,
EmployeeID = EmployeeID
};
db.tblSchedules.Add(sched);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Add Employee Schedule");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void updatePatient(PatientEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblPatient pat = db.tblPatients.Where(x => x.Id == obj.PatientId).FirstOrDefault();
pat.LastName = obj.LastName;
pat.FirstName = obj.FirstName;
pat.MiddleName = obj.MiddleName;
pat.FacilityID = obj.FacilityId;
pat.Active = obj.Active;
pat.DateCreated = obj.DateCreated;
pat.DateUpdated = obj.DateUpdated;
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Update Patient");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void getScheduleByFacility(string Date, int FacilityID)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
var res = db.tblSchedules.Where(z => z.Date == Date && z.FacilityID == FacilityID).Select(x => new ViewScheduleByFacilityAndStaff
{
Date = x.Date,
EmployeeName = x.tblEmployee.LastName.ToUpper() + ", " + x.tblEmployee.FirstName.ToUpper() + " " + x.tblEmployee.MiddleName.ToUpper(),
Facility = x.tblFacility.Name.ToUpper(),
Address = x.tblFacility.Address.ToUpper()
}).ToList();
ViewScheduleByFacilityAndStaffBindingSource.DataSource = res;
this.rptViewByFacility.RefreshReport();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Get Schedule By Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public PatientEntity searchPatientByID(int patientID)
{
PatientEntity obj = new PatientEntity();
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblPatient pat = db.tblPatients.FirstOrDefault(x => x.Id == patientID);
if (pat != null)
{
obj.PatientId = pat.Id;
obj.FacilityId = pat.FacilityID;
obj.FacilityName = pat.tblFacility.Name;
obj.LastName = pat.LastName;
obj.FirstName = pat.FirstName;
obj.MiddleName = pat.MiddleName;
obj.Active = pat.Active;
obj.DateCreated = pat.DateCreated;
obj.DateUpdated = pat.DateUpdated;
}
else
{
obj = null;
}
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Search Patient By ID");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
obj = null;
}
return(obj);
}
