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