public AppointView GetSoonestAppoints(AppointPaging model)
{
AppointView returnModel = new AppointView();
returnModel.appointList = new List <AppointDom>();
cmd.CommandText = "Appointment_Selectbyuserid";
cmd.Parameters.AddWithValue("@PageSize", model.PageSize);
cmd.Parameters.AddWithValue("@PageNum", model.PageNum);
cmd.Parameters.AddWithValue("@SortDir", model.SortDir);
cmd.Parameters.AddWithValue("@SortCol", model.SortCol);
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@CustFNameFilter", model.CustFNameFilter);
cmd.Parameters.AddWithValue("@CustLNameFilter", model.CustLNameFilter);
cmd.Parameters.AddWithValue("@AppointFilter", model.AppointFilter);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
short set = new short();
while (reader.Read())
{
switch (set)
{
case 0:
AppointDom viewModel = Mapper(reader);
returnModel.appointList.Add(viewModel);
break;
case 1:
returnModel.appointTotal = reader.GetInt32(0);
break;
}
}
conn.Close();
return(returnModel);
}
public async Task <IActionResult> GetUserInfo([FromBody] AppointPaging model)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await GetCurrentUser();
model.UserId = user.Id;
model.SortCol = "Id";
UserInfoView userinfo = new UserInfoView();
userinfo.appointView = _svc.GetSoonestAppoints(model);
userinfo.profDom = _service.Get(user.Id);
DataResponse <UserInfoView> info = new DataResponse <UserInfoView>();
info.Data = userinfo;
return(Ok(info));
}
catch (Exception ex)
{
return(StatusCode(404, ex));
}
}
