//Method to Activate LabIncharge Account
public string ActivateLabIncharge_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
LabIncharge LabIncharge1 = objHmsDataContext.LabIncharges.SingleOrDefault(id => (id.LabIncharge_ID == inchargeBO.pid || id.Email_ID == inchargeBO.emailID));
LabIncharge1.IsActive = true;
objHmsDataContext.SubmitChanges();
LabIncharge LabIncharge2 = objHmsDataContext.LabIncharges.SingleOrDefault(id => id.LabIncharge_ID == inchargeBO.pid);
return(" Account Activated");
}
}
catch (Exception e)
{
return("Unable To Activate Account Try again later");
}
}
//Method to deactivate LabIncharge account, with string return type
public string DeactivateLabIncharge_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
LabIncharge LabIncharge = objHmsDataContext.LabIncharges.SingleOrDefault(id => (id.LabIncharge_ID == inchargeBO.pid || id.Email_ID == inchargeBO.emailID));
LabIncharge.IsActive = false;
objHmsDataContext.SubmitChanges();
return("Account Deactivated Successfully");
}
}
catch (Exception e)
{
return("Unable to deactive please try again");
}
}
public IEnumerable <LabInchargeBO> UpdateLabIncharge_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
LabIncharge labIncharge = objHmsDataContext.LabIncharges.SingleOrDefault(pat => (pat.LabIncharge_ID == inchargeBO.pid || pat.Email_ID == inchargeBO.emailID));
LabIncharge updaterLabIncharge = ConvertBOToLabIncharge(labIncharge, inchargeBO);
objHmsDataContext.SubmitChanges();
return(GetAllLabInchargeDetials_DAL());
}
}
catch (Exception e)
{
return(GetAllLabInchargeDetials_DAL());
}
}
//Method to insert labincharge details into labincharge table, with return type lab incharge
public LabInchargeBO InsertInchargeDetails_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
{
LabIncharge labIncharge = new LabIncharge();
inchargeBO.isActive = true;
LabIncharge obj_incharge = ConvertBOToLabIncharge(labIncharge, inchargeBO);
objHmsDataContext.LabIncharges.InsertOnSubmit(obj_incharge);
objHmsDataContext.SubmitChanges();
LabInchargeBO labInchargeBO = GetLabInchargeDetials_DAL(inchargeBO);
return(labInchargeBO);
}
}
}
catch (Exception e)
{
LabInchargeBO labInc_BO = new LabInchargeBO();
return(labInc_BO);
}
}
//Method to update LabIncharge details SecurityQuestion, with string return type
public string UpdateLabInchargeDetails_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
LabIncharge labIncharge = objHmsDataContext.LabIncharges.SingleOrDefault(pat => (pat.LabIncharge_ID == inchargeBO.pid || pat.Email_ID == inchargeBO.emailID));
LabIncharge updaterLabIncharge = ConvertBOToLabIncharge(labIncharge, inchargeBO);
objHmsDataContext.SubmitChanges();
return("Successfullly Updated");
}
}
catch (Exception e)
{
return("Unable to update Please try once again");
}
}
// POST: api/LabIncharge
//Post action, which accepts Labincharge business object as parameter and same as return type
public LabInchargeBO Post([FromBody] LabInchargeBO inchargeBO)
{
LabInchargeBLLFactory inchargeBLLFactory = new LabInchargeBLLFactory();
LabInchargeBO updates = inchargeBLLFactory.CreateLabInchargeBLL().UpdateLabInchargeBLL().CreateLabInchargeDAL().InsertInchargeDetails_DAL(inchargeBO);
return(updates);
}
public string UserForgotPassword(Person _person)
{
var result = "";
if (_person.pid == 1)
{
AdministratorBLLFactory admin = new AdministratorBLLFactory();
AdministratorBO adminBO = new AdministratorBO();
adminBO.emailID = _person.emailID;
result = admin.CreateAdministratorBLL().ValidateAdminBLL().CreateAdminstratorDAL().ValidateEmailAdmin_DAL(_person.emailID);
}
else if (_person.pid == 2)
{
PatientBLLFactory patient = new PatientBLLFactory();
PatientBO patientBO = new PatientBO();
patientBO.emailID = _person.emailID;
result = patient.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().ValidateEmailPatient_DAL(patientBO);
}
else if (_person.pid == 3)
{
DoctorBLLFactory doctor = new DoctorBLLFactory();
DoctorBO doctorBO = new DoctorBO();
doctorBO.emailID = _person.emailID;
result = doctor.CreateDoctorBLL().ValidateDoctorBLL().CreateDoctorDAL().ValidateEmailDoctor_DAL(doctorBO);
}
else if (_person.pid == 4)
{
NurseBLLFactory nurse = new NurseBLLFactory();
NurseBO nurseBO = new NurseBO();
nurseBO.emailID = _person.emailID;
result = nurse.CreateNurseBLL().ValidateNurse().CreateNurseDAL().ValidateNurse_DAL(nurseBO);
}
else if (_person.pid == 5)
{
LabInchargeBLLFactory incharge = new LabInchargeBLLFactory();
LabInchargeBO inchargeBO = new LabInchargeBO();
inchargeBO.emailID = _person.emailID;
result = incharge.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().ValidateLabIncharge_DAL(inchargeBO);
}
if ((result) != "false" && result != "" && result != null)
{
EmailController email = new EmailController();
email.SendForgotPasswordEmail(result, _person.emailID);
return("Sent Password to Email");
}
else
{
return("User Do not exist");
}
}
public string RegisterNewIncharge([FromBody] LabInchargeBO inchargeBO)
{
LabInchargeBLLFactory inchargeBLLFactory = new LabInchargeBLLFactory();
LabInchargeBO updates = inchargeBLLFactory.CreateLabInchargeBLL().UpdateLabInchargeBLL().CreateLabInchargeDAL().InsertInchargeDetails_DAL(inchargeBO);
if (updates.pid != 0)
{
return("Your new User ID " + Convert.ToString(updates.pid) + "- Login Using this UserID");
}
return("Email ID is already Used by other User, try using other EmailID");
}
// GET: api/LabIncharge/5
//Get Action which accepts int and string parameter, return type lab incharge business object
public LabInchargeBO Get(int id, string pwd)
{
LabInchargeBLLFactory inchargeBLLFactory = new LabInchargeBLLFactory();
LabInchargeBO incharge_BO = new LabInchargeBO();
incharge_BO.pid = id;
incharge_BO.pwd = pwd;
LabInchargeBO inchargeBO = inchargeBLLFactory.CreateLabInchargeBLL().GetLabInchargeBLL().CreateLabInchargeDAL().GetLabInchargeDetials_DAL(incharge_BO);
return(inchargeBO);
}
// PUT: api/LabIncharge/5
//Put action which accepts int and labincharge business object as parameter, void as return type
public void Put(int id, [FromBody] LabInchargeBO inchargeBO)
{
LabInchargeBLLFactory inchargeBLLFactory = new LabInchargeBLLFactory();
string updates = inchargeBLLFactory.CreateLabInchargeBLL().UpdateLabInchargeBLL().CreateLabInchargeDAL().UpdateLabInchargeDetails_DAL(inchargeBO);
string Activate = inchargeBLLFactory.CreateLabInchargeBLL().ActivateLabInchargeBLL().CreateLabInchargeDAL().ActivateLabIncharge_DAL(inchargeBO);
string validate = inchargeBLLFactory.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().ValidateLabIncharge_DAL(inchargeBO);
string Deactive = inchargeBLLFactory.CreateLabInchargeBLL().DeActivateLabInchargeBLL().CreateLabInchargeDAL().DeactivateLabIncharge_DAL(inchargeBO);
string isavailable = inchargeBLLFactory.CreateLabInchargeBLL().IsAvailableEmailBLL().CreateLabInchargeDAL().CheckAvailability_DAL(inchargeBO);
}
public string GetUserName(int id)
{
string response = "No Name";
if (id > 3000 && id < 4000)
{
NurseBO nurseBo = new NurseBO();
nurseBo.pid = id;
NurseBLLFactory validatenurseBLLFactory = new NurseBLLFactory();
var NurseDetails = validatenurseBLLFactory.CreateNurseBLL().ValidateNurse().CreateNurseDAL().GetAllNurses_DAL().Where(d => d.pid == id).FirstOrDefault();
return(NurseDetails.firstName);
}
else if (id > 4000 && id < 5000)
{
LabInchargeBO inchargeBo = new LabInchargeBO();
inchargeBo.pid = id;
LabInchargeBLLFactory validateInchargeBLLFacotry = new LabInchargeBLLFactory();
var inchargeDetails = validateInchargeBLLFacotry.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().GetAllLabInchargeDetials_DAL().Where(d => d.pid == id).FirstOrDefault();
return(inchargeDetails.firstName);
}
else if (id > 5000 && id < 6000)
{
DoctorBO doctorBO = new DoctorBO();
doctorBO.pid = id;
DoctorBLLFactory doctorBLLFactory = new DoctorBLLFactory();
return(doctorBLLFactory.CreateDoctorBLL().ValidateDoctorBLL().CreateDoctorDAL().GetDoctorDetails_DAL(doctorBO).firstName);
}
else if (id > 6000 && id < 7000)
{
AdministratorBO adminBO = new AdministratorBO();
adminBO.pid = id;
AdministratorBLLFactory adminBLLFactory = new AdministratorBLLFactory();
return(adminBLLFactory.CreateAdministratorBLL().ValidateAdminBLL().CreateAdminstratorDAL().GetAdminDetailsByID_DAL(adminBO).firstName);
}
else if (id > 7000 && id < 8000)
{
PatientBO patientBO = new PatientBO();
patientBO.pid = id;
PatientBLLFactory patientBLLFactory = new PatientBLLFactory();
return(patientBLLFactory.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().GetPatientDetialsByID(patientBO).FirstOrDefault().firstName);
}
return(response);
}
//Method to check if emailID is already used, with string return type
public string CheckAvailability_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext ObjHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (ObjHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
ObjHmsDataContext.Connection.Open();
}
var emailID = (from LabIncharges in ObjHmsDataContext.LabIncharges
select LabIncharges.Email_ID == inchargeBO.emailID).SingleOrDefault();
//If emailId = true then Email_ID is already used
return(emailID.ToString());
}
}
catch (Exception e)
{ return("EmailID Validation failed"); }
}
//Convert LabIncharge to BO
public LabInchargeBO ConvertLabInchargeToBO(LabIncharge LabIncharge)
{
try
{
LabInchargeBO inchargeBO = new LabInchargeBO(LabIncharge.LabIncharge_ID, LabIncharge.First_Name, LabIncharge.Last_Name, LabIncharge.Email_ID,
LabIncharge.Password, LabIncharge.DateOfBirth, LabIncharge.Security_Question, LabIncharge.Security_Answer,
LabIncharge.Phone, LabIncharge.Address, LabIncharge.Gender, LabIncharge.IsActive);
if (!string.IsNullOrEmpty(inchargeBO.securityQn))
{
LabIncharge.Security_Question = inchargeBO.securityQn;
}
return(inchargeBO);
}
catch (Exception e)
{
LabInchargeBO incharge_BO = new LabInchargeBO();
return(incharge_BO);
}
}
public string ValidateEmailLabIncharge_DAL(LabInchargeBO inchargeBO)
{
try
{
var validateEmail = "false";
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
validateEmail = (from LabIncharge in objHmsDataContext.LabIncharges
where ((LabIncharge.Email_ID == inchargeBO.emailID))
select LabIncharge.Password).SingleOrDefault();
return(Convert.ToString(validateEmail));
}
}
catch (Exception e)
{
return("");
}
}
//Method to get LabIncharge details
public LabInchargeBO GetLabInchargeDetials_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
LabIncharge LabInchargeInfo = objHmsDataContext.LabIncharges.SingleOrDefault(incharge => ((incharge.LabIncharge_ID == inchargeBO.pid || incharge.Email_ID == inchargeBO.emailID) && (incharge.Password == inchargeBO.pwd)));
LabInchargeBO incharge_BO = ConvertLabInchargeToBO(LabInchargeInfo);
return(incharge_BO);
}
}
catch (Exception e)
{
return(null);
}
}
//Method To Validate LabIncharge login details, with string return type
public string ValidateLabIncharge_DAL(LabInchargeBO inchargeBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
bool validateEmail = (from LabIncharge in objHmsDataContext.LabIncharges
where ((LabIncharge.Email_ID == inchargeBO.emailID && LabIncharge.Password == inchargeBO.pwd) ||
(LabIncharge.LabIncharge_ID == inchargeBO.pid && LabIncharge.Password == inchargeBO.pwd))
select LabIncharge.IsActive).SingleOrDefault();
return(Convert.ToString(validateEmail));
}
}
catch (Exception e)
{
return("unable to validate User please try again later");
}
}
public IEnumerable <LabInchargeBO> UpdateLabIncharge(LabInchargeBO inchargeBO)
{
LabInchargeBLLFactory inchargeBLLFactory = new LabInchargeBLLFactory();
return(inchargeBLLFactory.CreateLabInchargeBLL().UpdateLabInchargeBLL().CreateLabInchargeDAL().UpdateLabIncharge_DAL(inchargeBO));
}
//Convert BO to LabIncharge
public LabIncharge ConvertBOToLabIncharge(LabIncharge labIncharge, LabInchargeBO inchargeBO)
{
if (inchargeBO.pid != 0)
{
labIncharge.LabIncharge_ID = inchargeBO.pid;
}
if (!string.IsNullOrEmpty(inchargeBO.firstName))
{
labIncharge.First_Name = inchargeBO.firstName;
}
if (!string.IsNullOrEmpty(inchargeBO.lastName))
{
labIncharge.Last_Name = inchargeBO.lastName;
}
if (!string.IsNullOrEmpty(inchargeBO.emailID))
{
labIncharge.Email_ID = inchargeBO.emailID;
}
if (!string.IsNullOrEmpty(inchargeBO.pwd))
{
labIncharge.Password = inchargeBO.pwd;
}
if (inchargeBO.dateOfBirth != DateTime.MinValue)
{
labIncharge.DateOfBirth = inchargeBO.dateOfBirth;
}
if (!string.IsNullOrEmpty(inchargeBO.phone))
{
labIncharge.Phone = inchargeBO.phone;
}
if (!string.IsNullOrEmpty(inchargeBO.address))
{
labIncharge.Address = inchargeBO.address;
}
if (!string.IsNullOrEmpty(inchargeBO.securityQn))
{
labIncharge.Security_Question = inchargeBO.securityQn;
}
if (!string.IsNullOrEmpty(inchargeBO.securityAns))
{
labIncharge.Security_Answer = inchargeBO.securityAns;
}
if (!string.IsNullOrEmpty(inchargeBO.gender))
{
labIncharge.Gender = inchargeBO.gender;
}
{
labIncharge.IsActive = inchargeBO.isActive;
}
return(labIncharge);
}
public int Authenticate(int id, string pwd)
{
int response = -1;
if (id > 3000 && id < 4000)
{
NurseBO nurseBo = new NurseBO();
nurseBo.pid = id;
nurseBo.pwd = pwd;
NurseBLLFactory validatenurseBLLFactory = new NurseBLLFactory();
string validateNurse = validatenurseBLLFactory.CreateNurseBLL().ValidateNurse().CreateNurseDAL().ValidateNurse_DAL(nurseBo);
if (validateNurse.Equals("True"))
{
response = 1;
}
else if (validateNurse.Equals("False"))
{
response = 0;
}
}
else if (id > 4000 && id < 5000)
{
LabInchargeBO inchargeBo = new LabInchargeBO();
inchargeBo.pid = id;
inchargeBo.pwd = pwd;
LabInchargeBLLFactory validateInchargeBLLFacotry = new LabInchargeBLLFactory();
string validateIncharge = validateInchargeBLLFacotry.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().ValidateLabIncharge_DAL(inchargeBo);
if (validateIncharge.Equals("True"))
{
response = 2;
}
else if (validateIncharge.Equals("False"))
{
response = 0;
}
}
else if (id > 5000 && id < 6000)
{
DoctorBO doctorBO = new DoctorBO();
doctorBO.pid = id;
doctorBO.pwd = pwd;
DoctorBLLFactory doctorBLLFactory = new DoctorBLLFactory();
string validateDoctor = doctorBLLFactory.CreateDoctorBLL().ValidateDoctorBLL().CreateDoctorDAL().ValidateDoctor_DAL(doctorBO);
if (validateDoctor.Equals("True"))
{
response = 3;
}
else if (validateDoctor.Equals("False"))
{
response = 0;
}
}
else if (id > 6000 && id < 7000)
{
AdministratorBO adminBO = new AdministratorBO();
adminBO.pid = id;
adminBO.pwd = pwd;
AdministratorBLLFactory adminBLLFactory = new AdministratorBLLFactory();
string validateAdmin = adminBLLFactory.CreateAdministratorBLL().ValidateAdminBLL().CreateAdminstratorDAL().ValidateAdmin_DAL(adminBO);
if (validateAdmin.Equals("True"))
{
response = 4;
}
else if (validateAdmin.Equals("False"))
{
response = 0;
}
}
else if (id > 7000 && id < 8000)
{
PatientBO patientBO = new PatientBO();
patientBO.pid = id;
patientBO.pwd = pwd;
PatientBLLFactory patientBLLFactory = new PatientBLLFactory();
string validatePatient = patientBLLFactory.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().ValidatePatient_DAL(patientBO);
if (validatePatient.Equals("True"))
{
response = 5;
}
else if (validatePatient.Equals("False"))
{
response = 0;
}
}
return(response);
}
