public void Create(WorkplaceOrder workplaceOrder)
{
Workplace workplace = sheringDBContext.Workplace.FirstOrDefault(e => e.Id == workplaceOrder.WorkplaceId);
sheringDBContext.WorkplaceOrder.Add(workplaceOrder);
sheringDBContext.SaveChanges();
}
public void GenerateMonitoring(int clientId)
{
DateTime curDate = DateTime.Now;
List <DateTime> dates = (from p in sheringDBContext.Diastance
select new DateTime(p.Date.Year, p.Date.Month, p.Date.Day)).Distinct().ToList();
//IEnumerable<DateTime> dates = sheringDBContext.Diastance
// .Where(y => y.Date.Year != DateTime.Now.Year
// && y.Date.Month != DateTime.Now.Month
// && y.Date.Day != DateTime.Now.Day)
// .Select(d => new {d.Date.Year, d.Date.Month, d.Date.Day})
// .Distinct()
// .ToList()
// .Select(x => new DateTime(x.Year, x.Month, x.Day));
foreach (var date in dates)
{
var mon = sheringDBContext.Monitoring
.FirstOrDefault(x => x.Date.Year == date.Year && x.Date.Month == date.Month && x.Date.Day == date.Day);
if (mon == null)
{
int rightCount = sheringDBContext.Diastance
.Count(x => x.DistanceValue >= 50 && x.DistanceValue <= 90);
int count = sheringDBContext.Diastance.Count();
double rightValues = 0;
if (count != 0)
{
rightValues = (double)((double)rightCount / count);
}
Monitoring monitoring = new Monitoring
{
ClientId = clientId,
Date = date,
RightValues = rightValues
};
IEnumerable <Distance> distances = sheringDBContext.Diastance
.Where(x => x.Date.Year == date.Year && x.Date.Month == date.Month && x.Date.Day == date.Day);
sheringDBContext.Diastance.RemoveRange(distances);
sheringDBContext.SaveChanges();
sheringDBContext.Monitoring.Add(monitoring);
sheringDBContext.SaveChanges();
}
}
}
public void Create(Client client)
{
sheringDBContext.Client.Add(client);
int n = sheringDBContext.SaveChanges();
if (n > 0)
{
cache.Set(client.Id, client, new MemoryCacheEntryOptions
{
AbsoluteExpirationRelativeToNow = TimeSpan.FromMinutes(5)
});
}
}
public ActionResult <string> Get(double id)
{
Distance distance = new Distance()
{
ClientId = 1008,
DistanceValue = id,
Date = DateTime.Now
};
sheringDBContext.Diastance.Add(distance);
sheringDBContext.SaveChanges();
return("value");
}
public void Save()
{
sheringDBContext.SaveChanges();
}
public void Create(SearchSetting searchSetting)
{
sheringDBContext.SearchSetting.Add(searchSetting);
sheringDBContext.SaveChanges();
}
public void Create(WorkplaceParameter workplace)
{
sheringDBContext.WorkplaceParameter.Add(workplace);
sheringDBContext.SaveChanges();
}
public void Create(Equipment equipment)
{
sheringDBContext.Equipment.Add(equipment);
sheringDBContext.SaveChanges();
}
public void Create(Landlord landlord)
{
sheringDBContext.Landlord.Add(landlord);
sheringDBContext.SaveChanges();
}
public void Create(Building building)
{
sheringDBContext.Building.Add(building);
sheringDBContext.SaveChanges();
}
public void Create(WorkplaceEquipment workplaceEquipment)
{
sheringDBContext.WorkplaceEquipment.Add(workplaceEquipment);
sheringDBContext.SaveChanges();
}