public List <MedicineReportView> GetMedicineMonthlyReport(string medicineView) { DataTable dataTable = _sqlHelper.GetMedicineMonthlyReport(medicineView); List <MedicineReportView> medicinesList = new List <MedicineReportView>(); for (int index = 0; index < dataTable.Rows.Count; index++) { MedicineReportView medicine = new MedicineReportView(); medicine.medicineName = dataTable.Rows[index]["MedicineName"].ToString(); medicine.quantityAssigned = (int)dataTable.Rows[index]["QuantityAssigned"]; medicine.batchNumber = (string)dataTable.Rows[index]["BatchNumber"]; medicine.allocationDate = ((DateTime)(dataTable.Rows[index]["AllocationDate"])).ToString("MMMM dd, yyyy"); medicine.departmentName = (dataTable.Rows[index]["DepartmentName"]).ToString(); medicinesList.Add(medicine); } return(medicinesList); }
public List <MedicineReportView> GetMedicineMovingRate(string medicineName) { DataTable dataTable = _sqlHelper.GetMedicineMovingRate(medicineName); List <MedicineReportView> medicineList = new List <MedicineReportView>(); for (int index = 0; index < dataTable.Rows.Count; index++) { MedicineReportView medicine = new MedicineReportView(); //medicine.allocationDate = dataTable.Rows[index]["AllocationDate"].ToString().Split(' ')[0]; medicine.allocationDate = dataTable.Rows[index]["AllocationDate"].ToString(); medicine.departmentName = dataTable.Rows[index]["DepartmentName"].ToString(); medicine.quantityAssigned = (int)dataTable.Rows[index]["QuantityAssigned"]; medicine.medicineName = medicineName; medicineList.Add(medicine); } return(medicineList); }