private List <Entities.PurchaseBill> GetPurchaseBills(IDataReader reader)
{
var purchaseBills = new List <Entities.PurchaseBill>();
while (reader.Read())
{
var purchaseBillItem = new PurchaseBillItem();
var purchaseBill = new Entities.PurchaseBill
{
PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", 0),
PurchaseBillNo = DRE.GetNullableString(reader, "purchase_bill_no", null),
PurchaseBillDate = DRE.GetNullableString(reader, "purchase_bill_date", null),
VendorId = DRE.GetNullableInt32(reader, "vendor_id", null),
VendorName = DRE.GetNullableString(reader, "vendor_name", null),
PurchaseBillAmount = DRE.GetNullableDecimal(reader, "purchase_bill_amount", 0),
AdjustedAmount = DRE.GetNullableDecimal(reader, "adjusted_amount", 0),
TotalBillQty = DRE.GetNullableDecimal(reader, "total_bill_qty", 0),
TotalBillAmount = DRE.GetNullableDecimal(reader, "total_bill_amount", 0),
Remarks = DRE.GetNullableString(reader, "remarks", null),
WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null),
FinancialYear = DRE.GetNullableString(reader, "financial_year", null),
PurchaseBillItems = purchaseBillItem.GetPurchaseBillItemDetailsByPurchaseBillId(DRE.GetInt32(reader, "purchase_bill_id"))
};
purchaseBills.Add(purchaseBill);
}
return(purchaseBills);
}
public List <Entities.PurchaseBillCharge> GetPurchaseBillChargesDetailsByPurchaseBillId(Int32 purchaseBillId)
{
var purchaseBillCharges = new List <Entities.PurchaseBillCharge>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPurchaseBillChargeDetailsByPurchaseBillId))
{
database.AddInParameter(dbCommand, "@purchase_bill_id", DbType.Int32, purchaseBillId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var purchaseBillCharge = new Entities.PurchaseBillCharge
{
PurchaseBillChargeId = DRE.GetNullableInt32(reader, "purchase_bill_charge_id", null),
PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", 0),
ChargeId = DRE.GetNullableInt32(reader, "charge_id", null),
ChargeAmount = DRE.GetNullableDecimal(reader, "charge_amount", null),
TaxPercent = DRE.GetNullableDecimal(reader, "tax_percent", null)
};
purchaseBillCharges.Add(purchaseBillCharge);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(purchaseBillCharges);
}
/// <summary>
///
/// </summary>
/// <param name="BranchId"></param>
/// <returns></returns>
public Entities.PatientPersonalHistory GetPatientPersonalHistoriesByPatientId(Int32 patientId)
{
var patientPersonalHistoryInfo = new Entities.PatientPersonalHistory();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPatientPersonalHistoryDetailsByPatientId))
{
database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, patientId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var patientPersonalHistory = new Entities.PatientPersonalHistory()
{
PatientPersonalHistoryId = DRE.GetNullableInt32(reader, "patient_personal_history_id", 0),
PatientId = DRE.GetNullableInt32(reader, "patient_id", 0),
MaritalStatus = DRE.GetNullableString(reader, "marital_status", null),
NoOfSons = DRE.GetNullableInt32(reader, "no_of_sons", 0),
NoOfDaughters = DRE.GetNullableInt32(reader, "no_of_daughters", 0),
PatientHeight = DRE.GetNullableDecimal(reader, "emp_height", null),
HeightUnit = DRE.GetNullableString(reader, "height_unit", null),
PatientWeight = DRE.GetNullableDecimal(reader, "emp_weight", null),
WeightUnit = DRE.GetNullableString(reader, "weight_unit", null),
Smoking = DRE.GetNullableString(reader, "smoking", null),
Alcohol = DRE.GetNullableString(reader, "alcohol", null),
Tobacco = DRE.GetNullableString(reader, "tobacco", null),
BloodGroupId = DRE.GetNullableInt32(reader, "blood_group_id", null),
BloodGroupFactorId = DRE.GetNullableInt32(reader, "blood_group_factor_id", null),
Diet = DRE.GetNullableString(reader, "diet", null),
AllergicTo = DRE.GetNullableString(reader, "allergic_to", null),
OtherAddictions = DRE.GetNullableString(reader, "other_addictions", null),
PresentIllness = DRE.GetNullableString(reader, "present_illness", null),
Treatment = DRE.GetNullableString(reader, "treatment", null),
Micturation = DRE.GetNullableString(reader, "micturation", null),
Bowels = DRE.GetNullableString(reader, "bowels", null),
Sleep = DRE.GetNullableString(reader, "sleep", null),
MC = DRE.GetNullableString(reader, "mc", null),
PastHistory = DRE.GetNullableString(reader, "past_history", null),
FamilyHistory = DRE.GetNullableString(reader, "family_history", null)
};
patientPersonalHistoryInfo = patientPersonalHistory;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(patientPersonalHistoryInfo);
}
public List <Entities.PurchaseBillItem> GetPurchaseBillItemDetailsByPurchaseBillId(Int32 purchaseBillId)
{
var purchaseBillItems = new List <Entities.PurchaseBillItem>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPurchaseBillItemDetailsByPurchaseBillId))
{
database.AddInParameter(dbCommand, "@purchase_bill_id", DbType.Int32, purchaseBillId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var purchaseBillItem = new Entities.PurchaseBillItem
{
PurchaseBillItemId = DRE.GetNullableInt32(reader, "purchase_bill_item_id", null),
PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", 0),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
GenericName = DRE.GetNullableString(reader, "generic_name", null),
BatchNo = DRE.GetNullableString(reader, "batch_no", null),
Pack1 = DRE.GetNullableDecimal(reader, "pack_1", null),
Pack2 = DRE.GetNullableDecimal(reader, "pack_2", null),
FreeQty = DRE.GetNullableDecimal(reader, "free_qty", null),
RatePerPack1 = DRE.GetNullableDecimal(reader, "rate_per_pack_1", null),
ExpiryDate = DRE.GetNullableString(reader, "expiry_date", null),
TaxPercent = DRE.GetNullableDecimal(reader, "tax_percent", null),
TaxAmount = DRE.GetNullableDecimal(reader, "tax_amount", null),
ItemAmount = DRE.GetNullableDecimal(reader, "item_amount", null)
};
purchaseBillItems.Add(purchaseBillItem);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(purchaseBillItems);
}
public List <Entities.DrugDispenseDrugReturn> GetDrugDispenseDetailsByPatientId(Int32 patientId)
{
var drugDispenses = new List <Entities.DrugDispenseDrugReturn>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetDrugDispenseDetailsByPatientId))
{
database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, patientId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugReturn = new Entities.DrugDispenseDrugReturn()
{
DrugDispenseDrugReturnId = DRE.GetNullableInt32(reader, "drug_dispense_drug_return_id", null),
DrugDispenseReturnId = DRE.GetNullableInt32(reader, "drug_dispense_return_id", null),
DrugUtilisationId = DRE.GetNullableInt32(reader, "drug_utilisation_id", null),
DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", null),
DrugDispenseNo = DRE.GetNullableInt32(reader, "drug_dispense_no", null),
DrugDispenseDate = DRE.GetNullableString(reader, "drug_dispense_date", null),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
DispenseQty = DRE.GetNullableDecimal(reader, "dispense_qty", null),
ReturnQty = DRE.GetNullableDecimal(reader, "return_qty", null),
BalanceQty = DRE.GetNullableDecimal(reader, "balance_qty", null),
Rate = DRE.GetNullableDecimal(reader, "purchase_rate", null),
Amount = DRE.GetNullableDecimal(reader, "amount", null)
};
drugDispenses.Add(drugReturn);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenses);
}
/// <summary>
/// Gets list of menus by role id.
/// </summary>
/// <param name="roleId">Specifies the role id.</param>
/// <returns>A collection of menus.</returns>
public List <Entities.Menu> GetMenusByRoleId(Int32 roleId)
{
var menus = new List <Entities.Menu>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfMenusByRole))
{
database.AddInParameter(dbCommand, "@role_id", DbType.Int32, roleId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var menu = new Entities.Menu
{
MenuId = DRE.GetNullableInt32(reader, "menu_id", 0),
MenuGroupId = DRE.GetNullableInt32(reader, "menu_group_id", 0),
MenuGroupName = DRE.GetNullableString(reader, "menu_group", null),
MenuName = DRE.GetNullableString(reader, "menu_name", null),
PageLink = DRE.GetNullableString(reader, "page_link", null),
MenuSequence = DRE.GetNullableDecimal(reader, "menu_sequence", 0),
MenuIcon = DRE.GetNullableString(reader, "menu_icon", null)
};
menus.Add(menu);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(menus);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.MedicalTestParameters> GetMedicalTestParameterDetailsByTestId(Int32 medicalTestId)
{
var medicalTestParameters = new List <Entities.MedicalTestParameters>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetMedicalTestParametersByTestId))
{
database.AddInParameter(dbCommand, "@medical_test_id", DbType.Int32, medicalTestId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var medicalTestParameter = new Entities.MedicalTestParameters()
{
MedicalTestParameterId = DRE.GetNullableInt32(reader, "medical_test_parameter_id", null),
MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", 0),
TestParameterName = DRE.GetNullableString(reader, "test_parameter_name", null),
TestParameterDesc = DRE.GetNullableString(reader, "test_parameter_desc", null),
TestParameterSequence = DRE.GetNullableDecimal(reader, "test_parameter_sequence", null),
MinimumValue = DRE.GetNullableDecimal(reader, "minimum_value", null),
MaximumValue = DRE.GetNullableDecimal(reader, "maximum_value", null),
NormalValue = DRE.GetNullableDecimal(reader, "normal_value", null),
UnitOfMeasurementId = DRE.GetNullableInt32(reader, "unit_of_measurement_id", null),
UnitCode = DRE.GetNullableString(reader, "unit_code", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
medicalTestParameters.Add(medicalTestParameter);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(medicalTestParameters);
}
//public List<Entities.PrecautionsList> GetDrugUtilisationByDrugDispenseId(Int32 drugDispenseId)
//{
// ///var drugDetails = new PrecautionsList();
// return GetDrugUtilisationByDrugDispenseId(drugDispenseId);
//}
public List <Entities.PrecautionsList> GetDrugUtilisationByDrugDispenseId(Int32 drugDispenseId)
{
var drugDispenseDrugUtilisations = new List <Entities.PrecautionsList>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetDrugDispenseDrugUtilisationDetailsByDrugDispenseId))
{
database.AddInParameter(dbCommand, "@drug_dispense_id", DbType.Int32, drugDispenseId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugUtilisation = new Entities.PrecautionsList()
{
DrugUtilisationId = DRE.GetNullableInt32(reader, "drug_utilisation_id", null),
DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", null),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
DispenseQty = Convert.ToString(DRE.GetNullableDecimal(reader, "dispense_qty", null)),
BalanceQty = DRE.GetNullableDecimal(reader, "balance_qty", null),
PurchaseRate = DRE.GetNullableDecimal(reader, "purchase_rate", null),
Amount = DRE.GetNullableDecimal(reader, "amount", null)
};
drugDispenseDrugUtilisations.Add(drugUtilisation);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenseDrugUtilisations);
}
public List <Entities.XRayFilmUsed> GetFilmUsedDetailsByXRayIssueId(Int32 xrayIssueId)
{
var xRayFilmsUsed = new List <Entities.XRayFilmUsed>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetXRayFilmsUsedDetailsByXRayIssueId))
{
database.AddInParameter(dbCommand, "@xray_issue_id", DbType.Int32, xrayIssueId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var xRayFilmUsed = new Entities.XRayFilmUsed()
{
XRayFilmUsedId = DRE.GetNullableInt32(reader, "xray_film_used_id", null),
XRayIssueId = DRE.GetNullableInt32(reader, "xray_issue_id", null),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
DispenseQty = DRE.GetNullableDecimal(reader, "dispense_qty", null),
BalanceQty = DRE.GetNullableDecimal(reader, "balance_qty", null),
PurchaseRate = DRE.GetNullableDecimal(reader, "purchase_rate", null),
Amount = DRE.GetNullableDecimal(reader, "amount", null)
};
xRayFilmsUsed.Add(xRayFilmUsed);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(xRayFilmsUsed);
}
/// <summary>
/// /
/// </summary>
/// <returns></returns>
public List <Entities.Pettycash> GetAllPettyCashDocno()
{
var Pettys = new List <Entities.Pettycash>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllPettycase))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var Petty = new Entities.Pettycash
{
PettycaseId = DRE.GetNullableInt32(reader, "pettycase_id", 0),
DocNo = DRE.GetNullableString(reader, "docno", null),
EntryDate = DRE.GetNullableString(reader, "Date", null),
DateRange = DRE.GetNullableString(reader, "daterange", null),
AccountHead = DRE.GetNullableString(reader, "account_head_name", null),
Supplier = DRE.GetNullableString(reader, "nameofsupplier", null),
VoucherNo = DRE.GetNullableString(reader, "voucherno", null),
Amount = DRE.GetNullableDecimal(reader, "Amount", 0),
guid = DRE.GetNullableGuid(reader, "row_guid", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
Pettys.Add(Petty);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Pettys);
}
public List <Entities.PurchaseBillReturnItem> GetPurchaseBillItemReturnDetailsByPurchaseBillReturnId(Int32 purchaseBillReturnId)
{
var purchaseBillItemsReturn = new List <Entities.PurchaseBillReturnItem>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPurchaseBillItemReturnDetailsByReturnId))
{
database.AddInParameter(dbCommand, "@purchase_bill_return_id", DbType.Int32, purchaseBillReturnId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var purchaseBillItemReturn = new Entities.PurchaseBillReturnItem
{
PurchaseBillItemReturnId = DRE.GetNullableInt32(reader, "purchase_bill_item_return_id", null),
PurchaseBillItemId = DRE.GetNullableInt32(reader, "purchase_bill_item_id", null),
PurchaseBillId = DRE.GetNullableInt32(reader, "purchase_bill_id", 0),
DrugId = DRE.GetNullableInt32(reader, "drug_id", null),
DrugCode = DRE.GetNullableInt32(reader, "drug_code", null),
DrugName = DRE.GetNullableString(reader, "drug_name", null),
PurchaseQty = DRE.GetNullableDecimal(reader, "free_qty", null),
ReturnQty = DRE.GetNullableDecimal(reader, "rate_per_pack_1", null)
};
purchaseBillItemsReturn.Add(purchaseBillItemReturn);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(purchaseBillItemsReturn);
}
