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