public List<RentalDTO> SearchRentalsAllStt(SearchRentalDTO dto) { RentalDTO rentalDto; List<RentalDTO> list = new List<RentalDTO>(); try { SqlDataReader reader = ConnectionManager.GetCommand("sp0004AllStt", new Dictionary<string, SqlDbType>() { {"@userName", SqlDbType.NVarChar}, {"@title", SqlDbType.NVarChar}, {"@fromDate", SqlDbType.DateTime}, {"@toDate", SqlDbType.DateTime} }, new List<object>() { dto.UserName, dto.Title, dto.FromDate, dto.ToDate }).ExecuteReader(); while (reader.Read()) { rentalDto = new RentalDTO(); rentalDto.Username = reader["Username"].ToString(); rentalDto.BookTitle = reader["Title"].ToString(); rentalDto.Barcode = reader["Barcode"].ToString(); rentalDto.IssueDate = DateTime.Parse(reader["IssuedDate"].ToString()); rentalDto.DueDate = DateTime.Parse(reader["DueDate"].ToString()); if (reader["ReturnDate"] == DBNull.Value) { rentalDto.ReturnDate = null; } else { rentalDto.ReturnDate = DateTime.Parse(reader["ReturnDate"].ToString()); } float fine; float.TryParse(reader["Fine"].ToString(), out fine); rentalDto.Fine = fine; int status; int.TryParse(reader["Status"].ToString(), out status); rentalDto.Status = (RentalStatus)Enum.Parse(typeof(RentalStatus), status.ToString()); int expandCount; int.TryParse(reader["ExpandCount"].ToString(), out expandCount); rentalDto.ExpandCount = expandCount; list.Add(rentalDto); } reader.Close(); } catch (Exception e) { Log.Error("Error at AuthorDAO - GetAuthorByID", e); return null; } return list; }
public List<RentalDTO> SearchRentals(SearchRentalDTO dto) { SearchRentalDAO dao = new SearchRentalDAO(); if(dto.Status==0) { return dao.SearchRentalsAllStt(dto); } else { return dao.SearchRentals(dto); } }
private void ResetListRental() { //_listRental = _feature.GetAllRental(); //grdRental.DataSource = _listRental; var rentalDto = new SearchRentalDTO(); rentalDto.Status = (int) RentalStatus.NEW; rentalDto.FromDate = dteRentalFrom.Text; rentalDto.ToDate = dteRentalTo.Text; rentalDto.PageNumber = 1; var rentalBus = new SearchRentalBUS(); grdRental.DataSource = rentalBus.SearchRentals(rentalDto); }
private void BtnRentalSearchClick(object sender, EventArgs e) { SearchRentalDTO rentalDto = new SearchRentalDTO(); rentalDto.Title = txtRentalTitle.Text; rentalDto.UserName = txtRentalUser.Text; rentalDto.Status = cboRentalStatus.SelectedIndex; rentalDto.FromDate = dteRentalFrom.Text; rentalDto.ToDate = dteRentalTo.Text; rentalDto.PageNumber = 1; SearchRentalBUS rentalBus = new SearchRentalBUS(); grdRental.DataSource = rentalBus.SearchRentals(rentalDto); }