public List <UnpaidBillWiseModel> UnpaidBillReport(string fromDate, string toDate) { SqlConnection con = new SqlConnection(connectionString); string query = @"select * from patient WHERE paymentStatus=0 ORDER BY createdAt DESC"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <UnpaidBillWiseModel> unpaBillViewModels = new List <UnpaidBillWiseModel>(); while (reader.Read()) { UnpaidBillWiseModel unpaidViewModel = new UnpaidBillWiseModel(); unpaidViewModel.PatientName = (reader["patientName"].ToString()); unpaidViewModel.BillNo = reader["billNo"].ToString(); unpaidViewModel.MobileNo = reader["mobile"].ToString(); unpaidViewModel.TotalAmount = Convert.ToDecimal(reader["dueAmount"].ToString()); unpaidViewModel.paymentStatus = reader["paymentStatus"].ToString() == "False" ? "Unpaid" : "Paid"; unpaBillViewModels.Add(unpaidViewModel); } reader.Close(); con.Close(); return(unpaBillViewModels); }
public List <UnpaidBillWiseModel> UnpaidBillReport(string fromDate, string toDate) { string query = @"select * from patient WHERE paymentStatus=0 ORDER BY created_at DESC"; command.CommandText = query; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <UnpaidBillWiseModel> unpaBillViewModels = new List <UnpaidBillWiseModel>(); while (reader.Read()) { UnpaidBillWiseModel unpaidViewModel = new UnpaidBillWiseModel(); unpaidViewModel.PatientName = (reader["patient_name"].ToString()); unpaidViewModel.BillNo = reader["bill_no"].ToString(); unpaidViewModel.MobileNo = reader["mobile"].ToString(); unpaidViewModel.TotalAmount = Convert.ToDecimal(reader["dueAmount"].ToString()); unpaBillViewModels.Add(unpaidViewModel); } reader.Close(); connection.Close(); return(unpaBillViewModels); }