/// <summary>
/// No Metadata Documentation available.
/// </summary>
/// <param name="apiContext"></param>
/// <param name="querySettings"></param>
/// <param name="users"></param>
/// <returns></returns>
public static Helpers.ActionResult Get(Helpers.ApiContext apiContext, Helpers.QuerySettings <Entities.User> querySettings, out System.Collections.Generic.List <Entities.User> users)
{
// API doesn't allow null parameters.
if (apiContext == null)
{
throw new System.ArgumentNullException("apiContext");
}
if (querySettings == null)
{
throw new System.ArgumentNullException("querySettings");
}
// Verify user is authorized to perform action, otherwise throw exception.
Security.SecurityHandler.SetApiContext(apiContext);
Helpers.ActionResult result = Helpers.ActionResult.Factory(true);
try
{
Model.OrmsContext context = (Model.OrmsContext)apiContext.CurrentContext;
// make entities query and set the NoTracking option to stop tracking of entities by entity framework
System.Data.Objects.ObjectQuery <Entities.User> query = context.Users;
query.MergeOption = System.Data.Objects.MergeOption.NoTracking;
// include entities
foreach (System.String include in querySettings.IncludedEntities)
{
query = query.Include(include);
}
// execute the query with query settings applied
users = query
.Where(querySettings.GetWhereExpression())
.OrderBy(querySettings.SortExpression)
.Skip(querySettings.ResultsStartIndex)
.Take(querySettings.MaxResultsSize)
.ToList();
}
catch (System.Exception ex)
{
object forDebugging = ex;
throw; // Helpers.Exceptions.GetEntityException.Factory(ex);
}
return(result);
}
public static IQueryable <MarketCarInfo> GetMarketCarInfoQuery(System.Data.Objects.ObjectQuery <carscom_from_year2004_to_year2005> objectQuery)
{
return(objectQuery.Select(i => new MarketCarInfo()
{
Address = i.Address,
AutoTrader = i.AutoTrader,
AutoTraderListingURL = i.AutoTraderListingURL,
AutoTraderStockNo = i.AutoTraderStockNo,
AutoTraderThumbnailURL = i.AutoTraderThumbnailURL,
CarsComThumbnailURL = i.CarsComThumbnailURL,
BodyStyle = i.BodyStyle,
CarsCom = i.CarsCom,
CarsComListingURL = i.CarsComListingURL,
CarsComStockNo = i.CarsComStockNo,
Certified = i.Certified,
CurrentPrice = i.CurrentPrice.Value,
DateAdded = i.DateAdded,
Dealershipname = i.Dealershipname,
Doors = i.Doors,
DriveType = i.DriveType,
Engine = i.Engine,
ExteriorColor = i.ExteriorColor,
Franchise = i.Franchise,
FuelType = i.FuelType,
InteriorColor = i.InteriorColor,
Latitude = i.Latitude,
Longitude = i.Longitude,
Make = i.Make,
Mileage = i.Mileage.Value,
Model = i.Model,
MoonRoof = i.MoonRoof,
MSRP = i.MSRP,
RegionalListingId = i.RegionalListingId,
StartingPrice = i.StartingPrice.Value,
State = i.State,
SunRoof = i.SunRoof,
Tranmission = i.Tranmission,
Trim = i.Trim,
Vin = i.Vin,
Year = i.Year
}));
}
/// <summary>
/// Fetches a range of items.
/// </summary>
/// <param name="startIndex">The start index.</param>
/// <param name="count">The number of items to fetch.</param>
/// <returns></returns>
public IList <ExportEtran.tbl_ConfRef> FetchRange(int startIndex, int count)
{
Trace.WriteLine("FetchRange: " + startIndex + "," + count);
Thread.Sleep(_fetchDelay);
/*List<ExportEtran.tbl_ConfRef> list = new List<ExportEtran.tbl_ConfRef>();
* for( int i=startIndex; i<startIndex+count; i++ )
* {
* ExportEtran.tbl_ConfRef customer = new ExportEtran.tbl_ConfRef { ConfRef_ID = i + 1, SrcTable = "Customer " + (i + 1) };
* list.Add(customer);
* }*/
ExportEtranEntities exportEtranEntities = new ExportEtranEntities();
System.Data.Objects.ObjectQuery <ExportEtran.tbl_ConfRef> tbl_ConfRefQuery = exportEtranEntities.tbl_ConfRef;
ObjectResult <ExportEtran.tbl_ConfRef> objectResult = tbl_ConfRefQuery.Execute(System.Data.Objects.MergeOption.AppendOnly);
List <ExportEtran.tbl_ConfRef> list = objectResult.Skip(startIndex).Take(count).ToList <ExportEtran.tbl_ConfRef>();
return(list);
}
public static Serialize.Consumers GetConsumers(String status)
{
Serialize.Consumer con = null;
Serialize.Consumers coll = new Serialize.Consumers();
using (TurbineModelContainer container = new TurbineModelContainer())
{
System.Data.Objects.ObjectQuery <Turbine.Data.JobConsumer> query = container.JobConsumers;
if (status != null)
{
query = container.JobConsumers.Where("it.status = @status",
new System.Data.Objects.ObjectParameter("status", status));
}
foreach (Turbine.Data.JobConsumer entity in query)
{
con = GetRepresentation(entity);
coll.Add(con);
}
}
return(coll);
}
/// <summary>
/// Method to parse the Events result query into actual controls.
/// </summary>
/// <param name="qryResults">Results set or the database query</param>
public void QryResultsToColumnControls(System.Data.Objects.ObjectQuery qryResults, List <NailVent> listNailVentToday, List <NailVent> listNailVentWeek, List <NailVent> listNailVentMonth)
{
DateTime dateNow = DateTime.Now;
string strDateNow = dateNow.ToString("d");
foreach (MVCEventBench.Models.Event result in qryResults)
{
//Create a new event
NailVent nv = new NailVent();
//Initialize the events main properties
nv.EventGUID = result.gEventGUID;
nv.Name = result.strEventName;
nv.Address = result.strEventAddress;
nv.Date = (DateTime)result.dEventDate;
nv.Time = result.strEventTime;
nv.Contact = result.strContact;
nv.Description = result.strDescription;
nv.Details = result.strDetails;
nv.PhoneNumber = result.strPhoneNumber;
nv.Sponsor = result.strSponsor;
nv.Webpage = result.strWebpage;
if (result.imgEvent != null)
{
nv.ImgPath = result.imgEvent.ToString();
}
//Initialize the properties
nv.AddressFontFamily = result.strAddressFontFamily;
nv.AddressFontSize = result.strAddressFontSize;
nv.DateFontFamily = result.strDateFontFamily;
nv.DateFontSize = result.strDateFontSize;
nv.TimeFontFamily = result.strTimeFontFamily;
nv.TimeFontSize = result.strTimeFontSize;
//If this is an event that is past date don't process it
DateTime.TryParse(strDateNow, out dateNow);
if (nv.Date < dateNow)
{
continue;
}
else
{
string strTimeCategory = FindEventTimeCategory(nv.Date);
switch (strTimeCategory)
{
case "day":
{
listNailVentToday.Add(nv);
break;
}
case "week":
{
listNailVentWeek.Add(nv);
break;
}
case "month":
{
listNailVentMonth.Add(nv);
break;
}
default:
{
break;
}
}
}
}
}
// Consumer grabs job in submit state off queue
public IJobConsumerContract GetNext()
{
IJobConsumerContract contract = new AspenJobConsumerContract();;
IConsumerContext ctx = AppUtility.GetConsumerContext();
Guid consumerId = ctx.Id;
using (TurbineModelContainer container = new TurbineModelContainer())
{
var consumer = container.JobConsumers
.SingleOrDefault <Turbine.Data.JobConsumer>(c => c.Id == consumerId);
if (consumer == null)
{
throw new IllegalAccessException("GetNext failed, Consumer is not registered");
}
if (consumer.status != "up")
{
throw new IllegalAccessException(String.Format(
"GetNext failed, Consumer status {0} != up", consumer.status));
}
//Job obj = container.Jobs.OrderBy("it.Submit").
// FirstOrDefault<Job>(s => s.State == "submit");
//obj.Simulation.ApplicationName
Job obj = null;
// TODO: CHange the WHERE clause to do an OR between all available applications
if (applications == null)
{
System.Data.Objects.ObjectQuery <Turbine.Data.Job> query = container.Jobs;
obj = query.OrderBy("it.Submit").FirstOrDefault <Job>(s => s.State == "submit");
}
else
{
foreach (string appName in applications)
{
System.Data.Objects.ObjectQuery <Turbine.Data.Job> query = container.Jobs;
query = query.Where("it.Simulation.ApplicationName = @appName",
new System.Data.Objects.ObjectParameter("appName", appName));
obj = query.OrderBy("it.Submit").FirstOrDefault <Job>(s => s.State == "submit");
if (obj != null)
{
break;
}
}
}
if (obj == null)
{
return(null);
}
// Need to Check that Consumer is up
obj.State = "locked";
try
{
container.SaveChanges();
}
catch (System.Data.OptimisticConcurrencyException)
{
Debug.WriteLine("OptimisticConcurrencyException: Failed attempt to lock job", GetType().Name);
return(null);
}
contract.Id = obj.Id;
}
return(contract);
}
