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