public void UpdateData(Position[] positions, Int64 lastModifiedDate, AucTraderDbContext db)
{
const int MX = 300;
int mx = MX;
DateTime baseDateTime = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
DateTime datetime = baseDateTime.AddMilliseconds(lastModifiedDate).ToLocalTime();
for (int i = 0; i < positions.Length; i++)
{
Position aucPosition = positions[i];
aucPosition.LoadDateTime = datetime;
db.Positions.Add(aucPosition);
if (i == mx)
{
mx += MX;
db.SaveChanges();
db.Dispose();
db = new AucTraderDbContext();
}
}
db.SaveChanges();
}
public ActionResult Update()
{
UpdateModel model = new UpdateModel()
{
Status = "Fail"
};
IAucDataLoader aucDataLoader = new AucDataLoader();
model.Data = aucDataLoader.GetAucResponse();
DateTime datetime;
var file = aucDataLoader.GetAucJsonFile(out datetime);
Task task = new Task(() =>
{
AucTraderDbContext db = new AucTraderDbContext();
const int MX = 300;
int mx = MX;
StringBuilder builder = new StringBuilder();
builder.Append("select * from Position where Auc in (");
Int64 last = file.AucPositions.Last().Auc;
file.AucPositions
.ForEach(el =>
{
builder.Append(el.Auc);
if (el.Auc != last)
{
builder.Append(", ");
}
});
builder.Append(")");
for (int i = 0; i < file.AucPositions.Length; i++)
{
Position aucPosition = file.AucPositions[i];
aucPosition.LoadDateTime = datetime;
db.Positions.Add((Position)aucPosition);
if (i == mx)
{
mx += MX;
db.SaveChanges();
db.Dispose();
db = new AucTraderDbContext();
}
}
db.SaveChanges();
});
task.Start();
return(View("Index", model));
}
public static List <Position> GetLastLoadPositions2()
{
AucTraderDbContext context = new AucTraderDbContext();
List <Position> lastPositions = context.Positions
.Where(el => el != null && el.WithdrawnDateTime == null)
.OrderBy(el => el.Auc)
.ToList();
return(lastPositions);
}
public static List <Position> GetLastLoadPositions()
{
AucTraderDbContext context = new AucTraderDbContext();
DateTime mxDate = context.Positions.Max(el => el.LoadDateTime);
List <Position> lastPositions = context.Positions
.Where(el => el.LoadDateTime == mxDate)
.OrderBy(el => el.Auc)
.ToList();
return(lastPositions);
}
