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); }