public int GetTransactionId() { int TId = 0; try { CriticareHospitalDataContext objData = new CriticareHospitalDataContext(); int Cnt = (from tbl in objData.tblCustomerTransactions select tbl).Count(); if (Cnt == 0) { TId = 1; } else { TId = Convert.ToInt32((from tbl in objData.tblCustomerTransactions select tbl).Max(e => e.TransactionId).Value); TId++; } } catch (Exception ex) { throw ex; } return(TId); }
public CompanyBLL() { objData = new CriticareHospitalDataContext(); // // TODO: Add constructor logic here // }
public DepartmentBLL() { objData = new CriticareHospitalDataContext(); // // TODO: Add constructor logic here // }
public AdvancePaymentBLL() { objData = new CriticareHospitalDataContext(); }
public BedStatusBLL() { objData = new CriticareHospitalDataContext(); }
public OTScheduleBLL() { objData = new CriticareHospitalDataContext(); }
public InsuranceComBLL() { objData = new CriticareHospitalDataContext(); }
public CompanyClaimBLL() { objData = new CriticareHospitalDataContext(); }
public OperationCategoryBLL() { objData = new CriticareHospitalDataContext(); }
public BirthCertificateBLL() { objData = new CriticareHospitalDataContext(); }
public IssueMaterialBLL() { objData = new CriticareHospitalDataContext(); }
public PatientAllocDocBLL() { objData = new CriticareHospitalDataContext(); }
public PatientInvoiceBLL() { objData = new CriticareHospitalDataContext(); }
public UserAuthenticationBLL() { objData = new CriticareHospitalDataContext(); }
public DocumentBLL() { objData = new CriticareHospitalDataContext(); }
public EmployeeBLL() { objData = new CriticareHospitalDataContext(); }
public DocCategoryBLL() { objData = new CriticareHospitalDataContext(); }
public PathologyBLL() { objData = new CriticareHospitalDataContext(); }
public MedicalCertificateBLL() { objData = new CriticareHospitalDataContext(); }
public BedMasterBLL() { objData = new CriticareHospitalDataContext(); }
public OTMedicineBillBLL() { objData = new CriticareHospitalDataContext(); }
public AllowanceDeductionBLL() { objData = new CriticareHospitalDataContext(); }
public TdsReportBLL() { objData = new CriticareHospitalDataContext(); }
public PatientMasterBLL() { objData = new CriticareHospitalDataContext(); }
public DatewiseCollectionBLL() { objData = new CriticareHospitalDataContext(); }
public PurchaseInvoiceBLL() { objData = new CriticareHospitalDataContext(); }
public List <sp_GetAllBedAllocOTResult> GetAllBedAllocOT() { try { List <sp_GetAllBedAllocOTResult> lstFinal = new List <sp_GetAllBedAllocOTResult>(); List <sp_GetAllBedAllocOTResult> lst = new CriticareHospitalDataContext().sp_GetAllBedAllocOT().ToList(); foreach (sp_GetAllBedAllocOTResult item in lst) { if (item.OTBedAllocId == null) { lstFinal.Add(item); } else { if (item.DischargeDate != null) { if (item.DischargeDate.Value.CompareTo(DateTime.Now) >= -1) { int cnt = (from tbl in lstFinal where tbl.BedId == item.BedId select tbl).ToList().Count; if (cnt == 0) { lstFinal.Add(item); } //else //{ // int indexc = 0; // bool flag = false; // foreach (sp_GetAllBedAllocOTResult finalBeds in lstFinal) // { // if (finalBeds.BedId==item.BedId) // { // flag = true; // break; // } // indexc++; // } // if (flag) // { // lstFinal.RemoveAt(indexc); // } //} } else { int cnt = (from tbl in lstFinal where tbl.BedId == item.BedId select tbl).ToList().Count; if (cnt == 0) { lstFinal.Add(item); } else { int indexc = 0; bool flag = false; foreach (sp_GetAllBedAllocOTResult finalBeds in lstFinal) { if (finalBeds.BedId == item.BedId) { flag = true; break; } indexc++; } if (flag) { lstFinal.RemoveAt(indexc); } } } } } } return(lstFinal); } catch (Exception ex) { throw ex; } }
public GetLoginBLL() { objData = new CriticareHospitalDataContext(); }
public SurgeryMasterBLL() { objData = new CriticareHospitalDataContext(); }
public AnaesthetistBLL() { objData = new CriticareHospitalDataContext(); }