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