public PartialViewResult ShowUserQuadTuneList(int quadID)
{
Session["quadID"] = quadID;
ViewBag.QuadID = quadID;
UserQuadTuneViewModel userQuadTuneViewModel = new UserQuadTuneViewModel();
userQuadTuneViewModel.GetFCSoftwareIDbyQuadID(quadID);
ViewBag.FlightControllerSoftwareID = userQuadTuneViewModel.FlightControllerSoftwareID;
return(PartialView("~/Views/_UserQuadTuneList.cshtml"));
}
public List <UserQuadTune> GetUserQuadTuneList(UserQuadTuneViewModel userQuadTuneViewModel, out int totalRecords)
{
pidhubEntities entity = new pidhubEntities();
var tunes = from t in entity.Tunes
.Include("Quad")
where t.Quad_ID == userQuadTuneViewModel.QuadID
select t;
string sortBy = userQuadTuneViewModel.sortBy;
string direction = userQuadTuneViewModel.direction;
switch (sortBy)
{
case "TuneName":
if (direction == "asc")
{
tunes = tunes.OrderBy(t => t.TuneName);
}
else
{
tunes = tunes.OrderByDescending(t => t.TuneName);
}
break;
default:
tunes = tunes.OrderBy(t => t.Tune_ID);
break;
}
totalRecords = tunes.Count();
if (userQuadTuneViewModel.page != null & userQuadTuneViewModel.limit != null)
{
int page = (int)userQuadTuneViewModel.page - 1;
int limit = (int)userQuadTuneViewModel.limit;
tunes = tunes.Skip(page * limit).Take(limit);
}
List <UserQuadTune> userQuadTuneList = new List <UserQuadTune>();
foreach (Tune tune in tunes.ToList())
{
userQuadTuneList.Add(new UserQuadTune()
{
TuneName = tune.TuneName,
TuneID = tune.Tune_ID,
});
}
return(userQuadTuneList);
}
public JsonResult GetUserQuadTuneList(int?page, int?limit, string sortBy, string direction, string searchString = null)
{
UserQuadTuneViewModel userQuadTuneViewModel = new UserQuadTuneViewModel();
int quadID = Convert.ToInt32(Session["quadID"]);
userQuadTuneViewModel.page = page;
userQuadTuneViewModel.limit = limit;
userQuadTuneViewModel.sortBy = sortBy;
userQuadTuneViewModel.direction = direction;
userQuadTuneViewModel.searchString = searchString;
userQuadTuneViewModel.QuadID = quadID;
userQuadTuneViewModel.GetUserQuadTuneList(userQuadTuneViewModel);
List <UserQuadTune> records = userQuadTuneViewModel.UserQuadTuneList;
int total = userQuadTuneViewModel.totalRecords;
JsonResult gridData = Json(new { records, total }, JsonRequestBehavior.AllowGet);
return(gridData);
}
