public ActionResult SearchArrivals(SearchArrivalsParametersVM model)
{
try
{
object sortColumn = "";
object sortDirection = "";
if (model.order.Count == 0)
{
sortColumn = "CreatedOn";
sortDirection = "desc";
}
else
{
sortColumn = model.columns[Convert.ToInt32(model.order[0].column)].data ?? (object)DBNull.Value;
sortDirection = model.order[0].dir ?? (object)DBNull.Value;
}
model.PageSize = Constants.PAGESIZE;
model.CreatedBy = LogInManager.LoggedInUserId;
model.IsAdminUser = LogInManager.HasRights("ADMIN");
var reservations = checkInCheckOutRepository.SearchArrivals(model, Convert.ToString(sortColumn), Convert.ToString(sortDirection));
int totalRecords = 0;
var dbRecords = reservations.Select(m => m.TotalCount).FirstOrDefault();
if (dbRecords != 0)
{
totalRecords = Convert.ToInt32(dbRecords);
}
#region Record Activity Log
RecordActivityLog.RecordActivity(Pages.SEARCH_ARRIVALS, "Searched data in arrivals page.");
#endregion
return(Json(new
{
IsSuccess = true,
CurrentPage = model.PageNum,
PageSize = Constants.PAGESIZE,
TotalRecords = totalRecords,
data = reservations
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "SearchArrivals");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}
public List <SearchArrivalsResultVM> SearchArrivals(SearchArrivalsParametersVM model, string sortColumn, string sortDirection)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@LastName", Value = model.LastName
},
new SqlParameter {
ParameterName = "@FirstName", Value = model.FirstName
},
new SqlParameter {
ParameterName = "@TARecordLocator", Value = model.TARecordLocator
},
new SqlParameter {
ParameterName = "@CompanyId", Value = model.CompanyId
},
new SqlParameter {
ParameterName = "@ContactId", Value = model.ContactId
},
new SqlParameter {
ParameterName = "@GroupId", Value = model.GroupId
},
new SqlParameter {
ParameterName = "@BlockCodeId", Value = model.BlockCodeId
},
new SqlParameter {
ParameterName = "@AgentId", Value = model.AgentId
},
new SqlParameter {
ParameterName = "@MemberTypeId", Value = model.MemberTypeId
},
new SqlParameter {
ParameterName = "@MemberNo", Value = model.MemberNo
},
new SqlParameter {
ParameterName = "@ArrivalDate", Value = model.ArrivalDate
},
new SqlParameter {
ParameterName = "@ConfirmationNo", Value = model.ConfirmationNo
},
new SqlParameter {
ParameterName = "@PostalCode", Value = model.PostalCode
},
new SqlParameter {
ParameterName = "@RoomNumber", Value = model.RoomNumber
},
new SqlParameter {
ParameterName = "@IsShowCheckedIn", Value = model.IsShowCheckedIn
},
new SqlParameter {
ParameterName = "@PageNum", Value = model.PageNum
},
new SqlParameter {
ParameterName = "@PageSize", Value = model.PageSize
},
new SqlParameter {
ParameterName = "@SortColumn", Value = sortColumn
},
new SqlParameter {
ParameterName = "@SortDirection", Value = sortDirection
},
new SqlParameter {
ParameterName = "@CreatedBy", Value = model.CreatedBy
},
new SqlParameter {
ParameterName = "@IsAdminUser", Value = model.IsAdminUser
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchArrivals", parameters);
var reservations = new List <SearchArrivalsResultVM>();
reservations = DALHelper.CreateListFromTable <SearchArrivalsResultVM>(dt);
return(reservations);
}
