public async Task <Vendor> Get(int Id)
{
using (var ctx = new MyTurnDb())
{
return(await ctx.Vendor.FindAsync(Id));
}
}
public async Task <Vendor> AddUpdate(Vendor vendor)
{
using (var ctx = new MyTurnDb()) {
var thisVendor = await ctx.Vendor
.Where(x => x.VendorDesc == vendor.VendorDesc || x.Id == vendor.Id)
.SingleOrDefaultAsync();
if (thisVendor == null)
{
vendor.CreateDate = DateTime.Now;
ctx.Vendor.Add(vendor);
var task = await ctx.SaveChangesAsync();
return(vendor);
}
else
{
thisVendor.Active = vendor.Active;
thisVendor.VendorDesc = vendor.VendorDesc;
var task = await ctx.SaveChangesAsync();
return(thisVendor);
}
}
}
public async Task <IList <Vendor> > Get()
{
using (var ctx = new MyTurnDb())
{
return(await ctx.Vendor.Where(x => x.Active).ToListAsync());
}
}
public async Task <IList <QueueHeader> > Get(int VendorId)
{
using (var ctx = new MyTurnDb())
{
return(await ctx.QueueHeader
.Where(x => x.VendorId == VendorId)
.ToListAsync());
}
}
public async Task <Person> Get(int Id)
{
using (var ctx = new MyTurnDb())
{
var jjj = await ctx.Person.FindAsync(Id);
return(jjj);
}
}
public async Task <IList <QueueDetail> > Get(int queueHeaderId)
{
using (var ctx = new MyTurnDb())
{
return(await ctx.QueueDetail
.Where(x => x.QueueHeaderId == queueHeaderId)
.OrderBy(x => x.Sort)
.ToListAsync());
}
}
public async Task <QueueDetail> Get(int queueHeaderId, int personId)
{
using (var ctx = new MyTurnDb())
{
return(await ctx.QueueDetail
.Where(x =>
x.QueueHeaderId == queueHeaderId &&
x.PersonId == personId)
.OrderBy(x => x.Sort).SingleOrDefaultAsync());
}
}
public async Task <QueueDetail> AddUpdate(QueueDetail queueDetail)
{
using (var ctx = new MyTurnDb()) {
var thisQueueDetail = await ctx.QueueDetail.FindAsync(queueDetail.Id);
if (thisQueueDetail == null)
{
var inLine = ctx.QueueDetail.Where(x =>
x.PersonId == queueDetail.PersonId && (
x.QueueStatusId == (int)EnumQueueStatus.InLine ||
x.QueueStatusId == (int)EnumQueueStatus.Bumped)).Any();
if (inLine)
{
return(new QueueDetail {
Id = -1
});
}
var maxSort = ctx.QueueDetail
.Where(x => x.QueueHeaderId == queueDetail.QueueHeaderId)
.Select(x => (decimal?)x.Sort)
.Max();
queueDetail.CreateDate = DateTime.Now;
queueDetail.Sort = (maxSort ?? 0) + 1;
ctx.QueueDetail.Add(queueDetail);
var task = await ctx.SaveChangesAsync();
return(queueDetail);
}
else
{
thisQueueDetail = queueDetail;
var task = await ctx.SaveChangesAsync();
return(thisQueueDetail);
}
}
}
public async Task <QueueHeader> AddUpdate(QueueHeader queueHeader)
{
using (var ctx = new MyTurnDb()) {
var thisQueueHeader = await ctx.QueueHeader.FindAsync(queueHeader.Id);
if (thisQueueHeader == null)
{
queueHeader.CreateDate = DateTime.Now;
ctx.QueueHeader.Add(queueHeader);
var task = await ctx.SaveChangesAsync();
return(queueHeader);
}
else
{
thisQueueHeader = queueHeader;
var task = await ctx.SaveChangesAsync();
return(thisQueueHeader);
}
}
}
public async Task <Person> AddUpdate(Person person)
{
using (var ctx = new MyTurnDb()) {
var thisPerson = ctx.Person
.Where(x => x.TelSms == person.TelSms)
.SingleOrDefault();
if (thisPerson == null)
{
person.CreateDate = DateTime.Now;
ctx.Person.Add(person);
var task = await ctx.SaveChangesAsync();
return(person);
}
else
{
thisPerson = person;
var task = await ctx.SaveChangesAsync();
return(thisPerson);
}
}
}
