public IHttpActionResult FindModel(string serial)
{
rfDbEntities db = new rfDbEntities();
var myQuery = from items in db.tblSerialNumbers where items.ModelSN == serial select items.ModelName;
if (myQuery.ToList().Count() > 0)
{
return(Ok(myQuery.ToList().ElementAt(0).ToString()));
}
else
{
return(Ok("na"));
}
}
public IHttpActionResult FindProduct(string model)
{
rfDbEntities db = new rfDbEntities();
var myQuery = from items in db.tblModelNames where items.ModelName == model select items.ProductType;
if (myQuery.ToList().Count() > 0)
{
return(Ok(myQuery.ToList().ElementAt(0).ToString()));
}
else
{
return(Ok("na"));
}
}
public IHttpActionResult GetTubes(string modelName)
{
var db = new rfDbEntities();
var myQuery = (from serialNums in db.tblSerialNumbers
join ateOut in db.tblATEOutput on serialNums.ModelSN equals ateOut.ModelSN
where serialNums.ModelName.Equals(modelName)
orderby ateOut.TubeName ascending
select ateOut).Select(x => x.TubeName).Distinct();
var tubeList = new List <string>();
foreach (var output in myQuery)
{
if (output != null)
{
tubeList.Add(output.ToString());
}
}
return(Ok(tubeList));
}
