// GET api/<controller>/5
//public string Get(int id)
//{
// return "value";
//}
public IEnumerable <RequestData> GetRequestByUser(string name)
{
RequestDAL dal = new RequestDAL();
List <RequestData> listData = dal.GetRequest(name);
return(listData);
}
/// <summary>
/// Date Created: 06/10/2011
/// Created By: Josephine Gad
/// (description) Get list of hotel/vehicle request
/// ---------------------------------------------
/// </summary>
/// <param name="DateFrom"></param>
/// <param name="DateTo"></param>
/// <param name="UserID"></param>
/// <param name="RegionID"></param>
/// <param name="CountryID"></param>
/// <param name="CityID"></param>
/// <param name="Status"></param>
/// <param name="FilterByNameID"></param>
/// <param name="FilterNameID"></param>
/// <param name="PortID"></param>
/// <param name="HotelID"></param>
/// <param name="VehicleID"></param>
/// <param name="VesselID"></param>
/// <param name="Nationality"></param>
/// <param name="Gender"></param>
/// <param name="Rank"></param>
/// <param name="Approved"></param>
/// <returns></returns>
public static DataTable GetRequest(string DateFrom, string DateTo,
string UserID, string RegionID, string CountryID, string CityID,
string Status, string FilterByNameID, string FilterNameID, string PortID,
string HotelID, string VehicleID, string VesselID, string Nationality,
string Gender, string Rank, string Approved, string Role)
{
DataTable dt = null;
try
{
dt = RequestDAL.GetRequest(DateFrom, DateTo, UserID, RegionID, CountryID,
CityID, Status, FilterByNameID, FilterNameID, PortID, HotelID, GlobalCode.Field2Int(VehicleID).ToString(),
VesselID, Nationality, Gender, Rank, Approved, Role);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
protected void btnLinQ_Click(object sender, EventArgs e)
{
RequestDAL dal = new RequestDAL();
string dt = txtDt.Text;
DataSet ds = dal.GetRequest(dt, null);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dataTB = ds.Tables[0];
var dataRow = dataTB.AsEnumerable().Where(x => x.Field <string>("REQUEST_ID") == txtSearch.Text);
DataTable result = dataRow.CopyToDataTable <DataRow>();
if (result != null && result.Rows.Count > 0)
{
ResultGridView.DataSource = result;
ResultGridView.DataBind();
}
else
{
ResultGridView.DataSource = null;
ResultGridView.DataBind();
}
}
}
public RequestDTO GetRequest(RequestDTO request)
{
var requests = RequestDAL.GetRequest(Map <Request>(request));
if (requests == null)
{
return(null);
}
return(Map <RequestDTO>(requests));
}
private void DisplayRequest(string username)
{
RequestDAL dal = new RequestDAL();
List <RequestData> listresult = dal.GetRequest(username);
if (listresult != null && listresult.Count > 0)
{
ResultGridView.DataSource = listresult;
ResultGridView.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string[] data_arr = new string[3];
data_arr[0] = txtSearch.Text;
data_arr[1] = txtSearcjNameSubject.Text;
data_arr[2] = txtDt.Text;
RequestDAL dal = new RequestDAL();
List <RequestData> listResult = dal.GetRequest(data_arr);
if (listResult != null && listResult.Count > 0)
{
ResultGridView.DataSource = listResult;
ResultGridView.DataBind();
}
}