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