public List <Frame> GetFrameList()
{
pidhubEntities entity = new pidhubEntities();
List <Frame> frameList = (from f in entity.Frames select f).ToList();
return(frameList);
}
public List <Prop> GetPropList()
{
pidhubEntities entity = new pidhubEntities();
List <Prop> PropList = (from p in entity.Props select p).ToList();
return(PropList);
}
public List <FlightControllerHardware> GetFCControllerHardwareList()
{
pidhubEntities entity = new pidhubEntities();
List <FlightControllerHardware> fcHardwareList = (from fch in entity.FlightControllerHardwares select fch).ToList();
return(fcHardwareList);
}
public TuneDetail GetTuneDetail(int tuneID)
{
pidhubEntities entity = new pidhubEntities();
var tuneDetailResult = (from tune in entity.Tunes
.Include("Quad")
.Include("Quad.UserAccount")
where (tune.Tune_ID == tuneID)
select tune).FirstOrDefault();
TuneDetail tuneDetail = new TuneDetail();
tuneDetail.TuneID = tuneDetailResult.Tune_ID;
tuneDetail.TuneName = tuneDetailResult.TuneName;
tuneDetail.MotorName = tuneDetailResult.Quad.Motor.MotorName;
tuneDetail.FlightControllerSoftwareID = tuneDetailResult.Quad.FlightControllerSoftwareID;
tuneDetail.FrameName = tuneDetailResult.Quad.Frame.FrameName;
tuneDetail.PropName = tuneDetailResult.Quad.Prop.PropName;
tuneDetail.ESCName = tuneDetailResult.Quad.ESC.ESCName;
tuneDetail.FlightControllerHardwareName = tuneDetailResult.Quad.FlightControllerHardware.FCHardwareName;
tuneDetail.FlightControllerSoftwareName = tuneDetailResult.Quad.FlightControllerSoftware.FCSoftwareName;
tuneDetail.PilotName = tuneDetailResult.Quad.UserAccount.PilotName;
tuneDetail.BatteryName = tuneDetailResult.Quad.Battery.BatteryName;
return(tuneDetail);
}
public List <ESC> GetESCList()
{
pidhubEntities entity = new pidhubEntities();
List <ESC> ESCList = (from e in entity.ESCs select e).ToList();
return(ESCList);
}
public SaveResult SaveTune(UserTuneViewModel userTuneViewModel)
{
SaveResult saveResult = new SaveResult();
try
{
pidhubEntities entity = new pidhubEntities();
Tune tune;
// if Tune ID is not present then create a new Tune, else get the existing entity
if (userTuneViewModel.TuneID == 0)
{
tune = new Tune();
}
else
{
tune = (from t in entity.Tunes
where t.Tune_ID == userTuneViewModel.TuneID
select t).FirstOrDefault();
}
// update values in entity
tune.Quad_ID = userTuneViewModel.QuadID;
tune.TuneName = userTuneViewModel.TuneName;
tune.Roll_P = userTuneViewModel.Roll_P;
tune.Pitch_P = userTuneViewModel.Pitch_P;
tune.Yaw_P = userTuneViewModel.Yaw_P;
tune.Roll_I = userTuneViewModel.Roll_I;
tune.Pitch_I = userTuneViewModel.Pitch_I;
tune.Yaw_I = userTuneViewModel.Yaw_I;
tune.Roll_D = userTuneViewModel.Roll_D;
tune.Pitch_D = userTuneViewModel.Pitch_D;
tune.Yaw_D = userTuneViewModel.Yaw_D;
tune.Roll_Rate = userTuneViewModel.Roll_Rate;
tune.Pitch_Rate = userTuneViewModel.Pitch_Rate;
tune.Pitch_RCRate = userTuneViewModel.Pitch_RCRate;
tune.Yaw_Rate = userTuneViewModel.Yaw_Rate;
tune.Yaw_RCRate = userTuneViewModel.Yaw_RCRate;
tune.Roll_RCRate = userTuneViewModel.Roll_RCRate;
tune.Roll_RCCurve = userTuneViewModel.Roll_RCCurve;
tune.Pitch_RCCurve = userTuneViewModel.Pitch_RCCurve;
tune.Yaw_RCCurve = userTuneViewModel.Yaw_RCCurve;
tune.Roll_RCExpo = userTuneViewModel.Roll_RCExpo;
tune.Pitch_RCExpo = userTuneViewModel.Pitch_RCExpo;
tune.Yaw_RCExpo = userTuneViewModel.Yaw_RCExpo;
// if this is a new Tune then must 'Add' to entity
if (userTuneViewModel.TuneID == 0)
{
entity.Tunes.Add(tune);
}
entity.SaveChanges();
}
catch (Exception ex)
{
saveResult.ErrorMessage = String.Format("There was an error saving your tune: {0}.", ex.Message);
}
return(saveResult);
}
public UserTuneViewModel GetUserTuneDetail(UserTuneViewModel userTuneViewModel)
{
pidhubEntities entity = new pidhubEntities();
var tune = (from t in entity.Tunes
where t.Tune_ID == userTuneViewModel.TuneID
select t).FirstOrDefault();
userTuneViewModel.QuadID = tune.Quad_ID;
userTuneViewModel.TuneID = tune.Tune_ID;
userTuneViewModel.FlightControllerSoftwareID = tune.Quad.FlightControllerSoftwareID;
userTuneViewModel.TuneName = tune.TuneName;
userTuneViewModel.Roll_P = tune.Roll_P == null ? 0 : tune.Roll_P;
userTuneViewModel.Pitch_P = tune.Pitch_P;
userTuneViewModel.Yaw_P = tune.Yaw_P;
userTuneViewModel.Roll_I = tune.Roll_I;
userTuneViewModel.Pitch_I = tune.Pitch_I;
userTuneViewModel.Yaw_I = tune.Yaw_I;
userTuneViewModel.Roll_D = tune.Roll_D;
userTuneViewModel.Pitch_D = tune.Pitch_D;
userTuneViewModel.Yaw_D = tune.Yaw_D;
userTuneViewModel.Roll_Rate = tune.Roll_Rate;
userTuneViewModel.Pitch_Rate = tune.Pitch_Rate;
userTuneViewModel.Yaw_Rate = tune.Yaw_Rate;
userTuneViewModel.Roll_RCRate = tune.Roll_RCRate;
userTuneViewModel.Pitch_RCRate = tune.Pitch_RCRate;
userTuneViewModel.Yaw_RCRate = tune.Yaw_RCRate;
userTuneViewModel.Roll_RCCurve = tune.Roll_RCCurve;
userTuneViewModel.Yaw_RCCurve = tune.Yaw_RCCurve;
userTuneViewModel.Roll_RCExpo = tune.Roll_RCExpo;
userTuneViewModel.Pitch_RCExpo = tune.Pitch_RCExpo;
userTuneViewModel.Yaw_RCExpo = tune.Yaw_RCExpo;
return(userTuneViewModel);
}
public List <Motor> GetMotorList()
{
pidhubEntities entity = new pidhubEntities();
List <Motor> motorList = (from m in entity.Motors select m).ToList();
return(motorList);
}
public UserAccountViewModel GetUserAccount(int userID)
{
UserAccountViewModel userViewModel = new UserAccountViewModel();
try
{
pidhubEntities entity = new pidhubEntities();
var user = (from ua in entity.UserAccounts
where ua.User_ID == userID
select ua).FirstOrDefault();
if (user != null)
{
userViewModel.UserID = user.User_ID;
userViewModel.PilotName = user.PilotName;
userViewModel.Email = user.Email;
userViewModel.Password = user.Password;
}
}
catch (Exception ex)
{
}
return(userViewModel);
}
public UserAccountViewModel CreateUserAccount(UserAccountViewModel userViewModel)
{
try
{
pidhubEntities entity = new pidhubEntities();
UserAccount userAccount = new UserAccount()
{
PilotName = userViewModel.PilotName,
Email = userViewModel.Email,
Password = userViewModel.Password
};
entity.UserAccounts.Add(userAccount);
entity.SaveChanges();
userViewModel.UserID = userAccount.User_ID;
}
catch (Exception ex)
{
//TODO Change method to return SaveResult
//saveResult.ErrorMessage = String.Format("There was an error creating your account {0}.", ex.Message);
}
return(userViewModel);
}
public List <Battery> GetBatteryList()
{
pidhubEntities entity = new pidhubEntities();
List <Battery> BatteryList = (from b in entity.Batteries select b).ToList();
return(BatteryList);
}
public int GetFCSoftwareIDbyQuadID(int quadID)
{
pidhubEntities entity = new pidhubEntities();
var fcID = (from q in entity.Quads
where q.Quad_ID == quadID
select q.FlightControllerSoftwareID).FirstOrDefault();
return(fcID);
}
public Quad GetQuadByQuadID(int quadID)
{
pidhubEntities entity = new pidhubEntities();
var quad = (from q in entity.Quads
where q.Quad_ID == quadID
select q).FirstOrDefault();
return(quad);
}
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 UserAccountViewModel ValidateUser(UserAccountViewModel userViewModel)
{
pidhubEntities entity = new pidhubEntities();
var userAccount = (from user in entity.UserAccounts
where user.Email == userViewModel.Email &&
user.Password == userViewModel.Password
select user).FirstOrDefault();
if (userAccount != null)
{
userViewModel.UserID = userAccount.User_ID;
userViewModel.PilotName = userAccount.PilotName;
return(userViewModel);
}
else
{
return(null);
}
}
public QuadDetailViewModel GetQuadDetail(QuadDetailViewModel quadDetailViewModel)
{
pidhubEntities entity = new pidhubEntities();
var quad = (from q in entity.Quads
where q.Quad_ID == quadDetailViewModel.QuadID
select q).FirstOrDefault();
quadDetailViewModel.UserID = quad.User_ID;
quadDetailViewModel.QuadName = quad.QuadName;
quadDetailViewModel.SelectedFCSoftwareID = quad.FlightControllerSoftwareID;
quadDetailViewModel.SelectedFCHardwareID = quad.FlightControllerHardwareID;
quadDetailViewModel.SelectedFrameID = quad.FrameID;
quadDetailViewModel.SelectedMotorID = quad.MotorID;
quadDetailViewModel.SelectedESCID = quad.ESCID;
quadDetailViewModel.SelectedPropID = quad.PropID;
quadDetailViewModel.SelectedBatteryID = quad.BatteryID;
return(quadDetailViewModel);
}
public SaveResult SaveQuad(QuadDetailViewModel quadDetailsViewModel)
{
SaveResult saveResult = new SaveResult();
try
{
pidhubEntities entity = new pidhubEntities();
Quad quad;
if (quadDetailsViewModel.QuadID == 0)
{
quad = new Quad();
}
else
{
quad = (from q in entity.Quads
where q.Quad_ID == quadDetailsViewModel.QuadID
select q).FirstOrDefault();
}
quad.User_ID = quadDetailsViewModel.UserID;
quad.QuadName = quadDetailsViewModel.QuadName;
quad.FlightControllerSoftwareID = quadDetailsViewModel.SelectedFCSoftwareID;
quad.FlightControllerHardwareID = quadDetailsViewModel.SelectedFCHardwareID;
quad.FrameID = quadDetailsViewModel.SelectedFrameID;
quad.MotorID = quadDetailsViewModel.SelectedMotorID;
quad.ESCID = quadDetailsViewModel.SelectedESCID;
quad.PropID = quadDetailsViewModel.SelectedPropID;
quad.BatteryID = quadDetailsViewModel.SelectedBatteryID;
if (quadDetailsViewModel.QuadID == 0)
{
entity.Quads.Add(quad);
}
entity.SaveChanges();
}
catch (Exception ex)
{
saveResult.ErrorMessage = String.Format("There was an error saving your quad: {0}.", ex.Message);
}
return(saveResult);
}
public SaveResult DeleteTune(int tuneID)
{
SaveResult saveResult = new SaveResult();
try
{
pidhubEntities entity = new pidhubEntities();
var tune = (from t in entity.Tunes
where t.Tune_ID == tuneID
select t).FirstOrDefault();
entity.Tunes.Remove(tune);
entity.SaveChanges();
}
catch (Exception ex)
{
saveResult.ErrorMessage = String.Format("There was an error deleting your Tune: {0}", ex.Message);
}
return(saveResult);
}
public SaveResult DeleteQuad(int quadID)
{
SaveResult saveResult = new SaveResult();
try
{
pidhubEntities entity = new pidhubEntities();
var quad = (from q in entity.Quads
where q.Quad_ID == quadID
select q).FirstOrDefault();
entity.Tunes.RemoveRange(quad.Tunes);
entity.Quads.Remove(quad);
entity.SaveChanges();
}
catch (Exception ex)
{
saveResult.ErrorMessage = String.Format("There was an error deleting your quad: {0}.", ex.Message);
}
return(saveResult);
}
public List <UserQuad> GetUserQuadList(UserQuadViewModel userQuadViewModel, out int totalRecords)
{
pidhubEntities entity = new pidhubEntities();
var quads = from q in entity.Quads
.Include("FlightControllerHardware")
.Include("FlightControllerSoftware")
.Include("Frame")
.Include("Battery")
.Include("ESC")
.Include("Prop")
.Include("Motor")
where q.User_ID == userQuadViewModel.userID
select q;
string sortBy = userQuadViewModel.sortBy;
string direction = userQuadViewModel.direction;
switch (sortBy)
{
case "QuadName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.QuadName);
}
else
{
quads = quads.OrderByDescending(t => t.QuadName);
}
break;
case "FrameName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.Frame.FrameName);
}
else
{
quads = quads.OrderByDescending(t => t.Frame.FrameName);
}
break;
case "FlightControllerSoftwareName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.FlightControllerSoftware.FCSoftwareName);
}
else
{
quads = quads.OrderByDescending(t => t.FlightControllerSoftware.FCSoftwareName);
}
break;
case "FlightControllerHardwareName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.FlightControllerHardware.FCHardwareName);
}
else
{
quads = quads.OrderByDescending(t => t.FlightControllerHardware.FCHardwareName);
}
break;
case "MotorName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.Motor.MotorName);
}
else
{
quads = quads.OrderByDescending(t => t.Motor.MotorName);
}
break;
case "ESCName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.ESC.ESCName);
}
else
{
quads = quads.OrderByDescending(t => t.ESC.ESCName);
}
break;
case "PropName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.Prop.PropName);
}
else
{
quads = quads.OrderByDescending(t => t.Prop.PropName);
}
break;
case "BatteryName":
if (direction == "asc")
{
quads = quads.OrderBy(t => t.Battery.BatteryName);
}
else
{
quads = quads.OrderByDescending(t => t.Battery.BatteryName);
}
break;
default:
quads = quads.OrderBy(t => t.Quad_ID);
break;
}
totalRecords = quads.Count();
if (userQuadViewModel.page != null & userQuadViewModel.limit != null)
{
int page = (int)userQuadViewModel.page - 1;
int limit = (int)userQuadViewModel.limit;
quads = quads.Skip(page * limit).Take(limit);
}
List <UserQuad> quadList = new List <UserQuad>();
foreach (Quad quad in quads.ToList())
{
quadList.Add(new UserQuad()
{
QuadID = quad.Quad_ID,
QuadName = quad.QuadName,
FlightControllerSoftwareName = quad.FlightControllerSoftware.FCSoftwareName,
FlightControllerHardwareName = quad.FlightControllerHardware.FCHardwareName,
FrameName = quad.Frame.FrameName,
MotorName = quad.Motor.MotorName,
ESCName = quad.ESC.ESCName,
PropName = quad.Prop.PropName,
BatteryName = quad.Battery.BatteryName,
});
}
return(quadList);
}
public List <QuadTune> GetSearchResults(SearchViewModel searchViewModel, out int totalRecords)
{
pidhubEntities entity = new pidhubEntities();
var searchResults = (from tune in entity.Tunes
.Include("Quad")
.Include("Quad.UserAccount")
select tune);
if (searchViewModel.SelectedFCHardwareID > 0)
{
searchResults = searchResults.Where(t => t.Quad.FlightControllerHardwareID == searchViewModel.SelectedFCHardwareID);
}
if (searchViewModel.SelectedFCSoftwareID > 0)
{
searchResults = searchResults.Where(t => t.Quad.FlightControllerSoftwareID == searchViewModel.SelectedFCSoftwareID);
}
if (searchViewModel.SelectedFrameID > 0)
{
searchResults = searchResults.Where(t => t.Quad.FrameID == searchViewModel.SelectedFrameID);
}
if (searchViewModel.SelectedMotorID > 0)
{
searchResults = searchResults.Where(t => t.Quad.MotorID == searchViewModel.SelectedMotorID);
}
if (searchViewModel.SelectedESCID > 0)
{
searchResults = searchResults.Where(t => t.Quad.ESCID == searchViewModel.SelectedESCID);
}
if (searchViewModel.SelectedPropID > 0)
{
searchResults = searchResults.Where(t => t.Quad.PropID == searchViewModel.SelectedPropID);
}
if (searchViewModel.SelectedBatteryID > 0)
{
searchResults = searchResults.Where(t => t.Quad.BatteryID == searchViewModel.SelectedBatteryID);
}
string sortBy = searchViewModel.sortBy;
string direction = searchViewModel.direction;
switch (sortBy)
{
case "PilotName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.UserAccount.PilotName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.UserAccount.PilotName);
}
break;
case "TuneName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.TuneName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.TuneName);
}
break;
case "FrameName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.Frame.FrameName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.Frame.FrameName);
}
break;
case "MotorName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.Motor.MotorName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.Motor.MotorName);
}
break;
case "ESCName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.ESC.ESCName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.ESC.ESCName);
}
break;
case "FlightControllerHardwareName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.FlightControllerHardware.FCHardwareName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.FlightControllerHardware.FCHardwareName);
}
break;
case "FlightControllerSoftwareName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.FlightControllerSoftware.FCSoftwareName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.FlightControllerSoftware.FCSoftwareName);
}
break;
case "PropName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.Prop.PropName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.Prop.PropName);
}
break;
case "BatteryName":
if (direction == "asc")
{
searchResults = searchResults.OrderBy(t => t.Quad.Battery.BatteryName);
}
else
{
searchResults = searchResults.OrderByDescending(t => t.Quad.Battery.BatteryName);
}
break;
default:
searchResults = searchResults.OrderBy(t => t.Tune_ID);
break;
}
totalRecords = searchResults.Count();
if (searchViewModel.page != null & searchViewModel.limit != null)
{
int page = (int)searchViewModel.page - 1;
int limit = (int)searchViewModel.limit;
searchResults = searchResults.Skip(page * limit).Take(limit);
}
List <QuadTune> quadTuneList = new List <QuadTune>();
foreach (Tune tune in searchResults.ToList())
{
quadTuneList.Add(new QuadTune()
{
QuadID = tune.Quad.Quad_ID,
QuadName = tune.Quad.QuadName,
TuneID = tune.Tune_ID,
TuneName = tune.TuneName,
PilotName = tune.Quad.UserAccount.PilotName,
FlightControllerSoftwareName = tune.Quad.FlightControllerSoftware.FCSoftwareName,
FlightControllerHardwareName = tune.Quad.FlightControllerHardware.FCHardwareName,
FrameName = tune.Quad.Frame.FrameName,
MotorName = tune.Quad.Motor.MotorName,
ESCName = tune.Quad.ESC.ESCName,
PropName = tune.Quad.Prop.PropName,
BatteryName = tune.Quad.Battery.BatteryName
});
}
return(quadTuneList);
}
