public DataTable GetAllTests()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllTests");
}
catch (Exception ex)
{
Commons.FileLog("TestMethodBLL - GetAllTests()", ex);
}
return ldt;
}
public DataTable GetPathologyTests()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("STP_SelectPathology");
}
catch (Exception ex)
{
throw ex;
}
return(ldt);
}
public DataTable GetNewReligionCode()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewTabletCode");
}
catch (Exception ex)
{
Commons.FileLog("TabletMasterBLL - GetNewReligionCode()", ex);
}
return(ldt);
}
public DataTable GetNewOPDBillNo()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewOPDBillNo");
}
catch (Exception ex)
{
throw ex;
}
return(ldt);
}
public DataTable GetAllBedMasters()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_SelectAllBeds");
}
catch (Exception ex)
{
throw ex;
}
return(ldt);
}
public DataTable GetNewSupplierCode()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewSupplierCode");
}
catch (Exception ex)
{
throw ex;
}
return(ldt);
}
public DataTable GetAllRequisitionDetails()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllRequisitionDetails");
}
catch (Exception ex)
{
Commons.FileLog("RequisitionDetailsBLL - GetAllRequisitionDetails()", ex);
}
return(ldt);
}
//public DataTable GetNewOccupationCode()
//{
// DataTable ldt = new DataTable();
// try
// {
// ldt = mobjDataAcces.GetDataTable("sp_GetNewOccupationCode");
// }
// catch (Exception ex)
// {
// Commons.FileLog("OccupationBLL - GetNewOccupationCode()", ex);
// }
// return ldt;
//}
public DataTable GetAllOccupation()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllOccupation");
}
catch (Exception ex)
{
Commons.FileLog("OccupationBLL - GetAllOccupation()", ex);
}
return(ldt);
}
public DataTable GetNewPatientCode()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewPatientTypeCode");
}
catch (Exception ex)
{
Commons.FileLog("PatientTypeBLL - GetNewPatientCode()", ex);
}
return(ldt);
}
public DataTable GetAllBedMasters()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllOccupiedBeds");
}
catch (Exception ex)
{
Commons.FileLog("BedStatusBLL - GetAllBedMasters()", ex);
}
return(ldt);
}
public DataTable GetNewDignosisCode()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewDignosisCode");
}
catch (Exception ex)
{
Commons.FileLog("DignosisBLL - GetNewDignosisCode()", ex);
}
return(ldt);
}
public System.Data.DataTable GetAllNonAllocPatient()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllNonAllocPatientList");
}
catch (Exception ex)
{
throw ex;
}
return(ldt);
}
public DataTable GetEmployee()
{
DataTable dt = new DataTable();
try
{
dt = mobjDataAccess.GetDataTable("sp_GetEmployees");
}
catch (Exception ex)
{
Commons.FileLog("RegistrationBLL - sp_GetEmployees()", ex);
}
return(dt);
}
public DataTable GetDocuments()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAccess.GetDataTable("sp_SelectDocuments");
}
catch (Exception ex)
{
Commons.FileLog("ManualQuotationBLL - GetDocuments()", ex);
}
return(ldt);
}
public DataTable GetConsultants()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetConsultants");
}
catch (Exception ex)
{
Commons.FileLog("ConsultantChargeBLL - GetConsultants()", ex);
}
return(ldt);
}
public DataTable GetAllProduct()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllProduct");
}
catch (Exception ex)
{
Commons.FileLog("ProductBLL - GetAllProduct()", ex);
}
return(ldt);
}
public System.Data.DataTable GetAllTest()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllTest");
}
catch (Exception ex)
{
Commons.FileLog("TestBLL - GetAllTest()", ex);
}
return(ldt);
}
public DataTable GetAllCountryForState()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllCountryForState");
}
catch (Exception ex)
{
Commons.FileLog("StateBLL - GetAllCountryForState()", ex);
}
return(ldt);
}
public DataTable GetLogin(EntityLogin entLogin)
{
DataTable dt = new DataTable();
List <SqlParameter> lstParam = new List <SqlParameter>();
try
{
Commons.ADDParameter(ref lstParam, "@UserName", DbType.String, entLogin.UserName);
Commons.ADDParameter(ref lstParam, "@Password", DbType.String, entLogin.Password);
Commons.ADDParameter(ref lstParam, "@UserType", DbType.String, entLogin.UserType);
dt = mobjDataAccess.GetDataTable("sp_GetLogin", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("GetLoginBLL - GetLogin(EntityLogin entLogin)", ex);
}
return(dt);
}
public DataTable GetData()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetShortItemList");
}
catch (Exception ex)
{
Commons.FileLog("StoreMainBLL - GetData()", ex);
}
return(ldt);
}
public System.Data.DataTable GetAllCategoryName()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllOperationCategoryName");
}
catch (Exception ex)
{
Commons.FileLog("OpeartionCategoryBLL - GetAllCategoryName()", ex);
}
return(ldt);
}
//SELECT
//tblEmployee.DesignationId,
//tblDesignationMaster.DesignationDesc,
//tblEmployee.EmpFirstName,
//tblEmployee.EmpMiddleName,
//tblEmployee.EmpLastName
//FROM
//tblEmployee
//INNER JOIN
//tblDesignationMaster
//ON
//tblEmployee.DesignationId = tblDesignationMaster.PKId
//WHERE
//tblEmployee.DesignationId=1 or tblEmployee.DesignationId=9
//and tblEmployee.PKId
//not in
//(select DocId from tblDocCategory
//where IsDelete='False')
public DataTable GetAllNonAllocDoc()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("STP_NotAllocatedDocToOperation");
}
catch (Exception ex)
{
Commons.FileLog("ShiftBLL - GetAllShift()", ex);
}
return(ldt);
}
public DataTable GetTablet()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetTabletForPresc");
}
catch (Exception ex)
{
Commons.FileLog("PrescriptionBLL - GetTablet()", ex);
}
return(ldt);
}
public DataTable GetConsultDoctor()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllAnaesthetist");
}
catch (Exception ex)
{
Commons.FileLog("AllocConsultDoctorToPatientBLL - GetConsultDoctor()", ex);
}
return(ldt);
}
public DataTable Checkpass(EntityLogin entLogin)
{
DataTable ldt = new DataTable();
List <SqlParameter> lstparam = new List <SqlParameter>();
try
{
Commons.ADDParameter(ref lstparam, "@UserName", DbType.String, entLogin.UserName);
ldt = mobjDataAccess.GetDataTable("sp_CheckPass", lstparam);
}
catch (Exception ex)
{
Commons.FileLog("GetChangePasswordBLL -Checkpass(EntityLogin entChk)", ex);;
}
return(ldt);
}
public DataTable GetNewRequisitionNo()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewRequisitionNo");
}
catch (Exception ex)
{
Commons.FileLog("MaterialRequisitionBLL - GetNewRequisitionNo()", ex);
}
return(ldt);
}
public DataTable SelectEmployeeList(int id)
{
DataTable ldt = new DataTable();
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@SalId", DbType.String, id);
ldt = mobjDataAcces.GetDataTable("STP_Select_SalaryEdit", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("EntityPathology - SelectPatientTest()", ex);
}
return(ldt);
}
public System.Data.DataTable GetAllRoomDetails()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetAllRoomDetails");
}
catch (Exception ex)
{
Commons.FileLog("RoomMasterBLL - GetAllRoomDetails()", ex);
}
return(ldt);
}
public DataTable GetNewAppoinmentCode()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewAppoinmentCode");
}
catch (Exception ex)
{
Commons.FileLog("BookAppoinmentBLL - GetNewAppoinmentCode()", ex);
}
return(ldt);
}
public DataTable GetNewInwardNo()
{
DataTable ldt = new DataTable();
try
{
ldt = mobjDataAcces.GetDataTable("sp_GetNewInwardNo");
}
catch (Exception ex)
{
Commons.FileLog("MterialInwardBLL - GetNewInwardNo()", ex);;
}
return(ldt);
}