public List<BookRegisterDTO> SearchRequests(SearchRequestDTO dto)
{
SearchRequestDAO dao = new SearchRequestDAO();
if(dto.Status==0)
{
return dao.SearchRequestAllStt(dto);
//break;
}
else
{
return dao.SearchRequests(dto);
}
}
public List<BookRegisterDTO> SearchRequests(SearchRequestDTO dto)
{
BookRegisterDTO bookReg;
List<BookRegisterDTO> list = new List<BookRegisterDTO>();
try
{
SqlDataReader reader = ConnectionManager.GetCommand("sp0003",
new Dictionary<string, SqlDbType>()
{
{"@userName", SqlDbType.NVarChar},
{"@title", SqlDbType.NVarChar},
{"@status", SqlDbType.Int},
{"@fromDate", SqlDbType.DateTime},
{"@toDate", SqlDbType.DateTime}
},
new List<object>()
{
dto.UserName,
dto.Title,
dto.Status,
dto.FromDate,
dto.ToDate
}).ExecuteReader();
while (reader.Read())
{
bookReg = new BookRegisterDTO();
bookReg.Username = reader["Username"].ToString();
bookReg.BookTitle = reader["Title"].ToString();
bookReg.RegisterDate = DateTime.Parse(reader["RegisterDate"].ToString());
bookReg.Note = reader["Note"].ToString();
int status;
int.TryParse(reader["Status"].ToString(), out status);
bookReg.Status = (BookRegisterStatus)Enum.Parse(typeof(BookRegisterStatus), status.ToString());
list.Add(bookReg);
}
reader.Close();
}
catch (Exception e)
{
Log.Error("Error at AuthorDAO - GetAuthorByID", e);
return null;
}
return list;
}
private void ResetListRequest()
{
//_listRegister = _feature.GetAllRegister();
//grdRegister.DataSource = _listRegister;
var rDto = new SearchRequestDTO();
rDto.Status = (int) BookRegisterStatus.NEW;
rDto.FromDate = dteRequestFrom.Value.ToShortDateString();
rDto.ToDate = dteRequestTo.Value.ToShortDateString();
rDto.PageNumber = 1;
var rBus = new SearchRequestBUS();
grdRegister.DataSource = rBus.SearchRequests(rDto);
}
private void BtnRegisterSearchClick(object sender, EventArgs e)
{
SearchRequestDTO rDto = new SearchRequestDTO();
rDto.UserName = txtRequestUser.Text;
rDto.Title = txtRequestTitle.Text;
rDto.Status = cboRequestStatus.SelectedIndex;
rDto.FromDate = dteRequestFrom.Text;
rDto.ToDate = dteRequestTo.Text;
rDto.PageNumber = 1;
SearchRequestBUS rBus = new SearchRequestBUS();
grdRegister.DataSource = rBus.SearchRequests(rDto);
}
