public List <UnpaidManager> GetUnpaidTotalInfo(UnpaidClass aUnpaidClass)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM t_TestReqEntry WHERE Date BETWEEN '" + aUnpaidClass.Fromdate + "' and '" +
aUnpaidClass.Todate + "' and DueAmount>0";
SqlCommand command = new SqlCommand(query, connection);
List <UnpaidManager> aList = new List <UnpaidManager>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
UnpaidManager aUnpaidManager = new UnpaidManager();
aUnpaidManager.BillNo = Convert.ToInt32(reader["BillNo"].ToString());
aUnpaidManager.MobileNo = reader["MobileNo"].ToString();
aUnpaidManager.PatientName = reader["Name"].ToString();
aUnpaidManager.DueAmount = Convert.ToDouble(reader["DueAmount"].ToString());
aUnpaidManager.TotalDue = aUnpaidManager.GetTotalDue(aUnpaidManager.DueAmount);
aUnpaidClass.Total += aUnpaidManager.TotalDue;
aList.Add(aUnpaidManager);
}
reader.Close();
}
connection.Close();
return(aList);
}
protected void searchButton_Click(object sender, EventArgs e)
{
UnpaidClass aUnpaidClass = new UnpaidClass();
UnpaidManager aManager = new UnpaidManager();
aUnpaidClass.Fromdate = Convert.ToDateTime(fromDateTextBox.Text);
aUnpaidClass.Todate = Convert.ToDateTime(toDateTextBox.Text);
List <UnpaidManager> aList = aManager.GetUnpaidTotalInfo(aUnpaidClass);
totalTextBox.Text = aUnpaidClass.Total.ToString();
showGridView.DataSource = aList;
showGridView.DataBind();
}
protected void showButton_Click(object sender, EventArgs e)
{
UnpaidManager aManager = new UnpaidManager();
List <Patient> unPaidBilList = new List <Patient>();
UnPaidBill aBill = new UnPaidBill();
aBill.FromDate = Convert.ToDateTime(fromDateTextBox.Value);
aBill.ToDate = Convert.ToDateTime(toDateTextBox.Value);
double total = 0;
unPaidBilList = aManager.GetUnPaidBiilInfo(aBill);
showGridView.DataSource = unPaidBilList;
showGridView.DataBind();
foreach (GridViewRow row in showGridView.Rows)
{
total += Convert.ToDouble(((Label)row.FindControl("totalLabel")).Text);
}
totalTextBox.Text = total.ToString();
}
