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();
}
public List <UnpaidManager> GetUnpaidTotalInfo(UnpaidClass aUnpaidClass)
{
return(aUnpaidGetWay.GetUnpaidTotalInfo(aUnpaidClass));
}
