public IActionResult Index()
{
PlacementContext context = new PlacementContext();
var students = context.Placements;
return(View());
}
public string getAvgDaysLapsedReport(string input)
{
var _placements = new List <Placement>();
var _placements2 = new List <string>();
var _placements3 = new double();
var _placements4 = new List <string>();
var _placements5 = new List <Placement>();
var _placements6 = new List <int>();
using (PlacementContext context = new PlacementContext())
{
var placements = (from s in context.Placements
//.OrderBy(s=> s.DaysLapsed)
.Take(500)
.Where(c => c.MoveInDate != null && c.MoveOutDate != null && c.ListedDate != null)
select s).ToList <Placement>();
_placements = placements;
_placements4 = _placements.Select(c => c.Community).ToList();
_placements6 = _placements.Select(c => c.DaysLapsed).ToList();
_placements3 = _placements.Where(c => c.MoveInDate == null).Select(x => x.DaysLapsed).DefaultIfEmpty().Average();
var car = placements.GroupBy(p => p.Community);
//_placements3 = _placements.Where(c => c.MoveInDate == null).Average(c => c.DaysLapsed);
//placements.GroupBy(p => p.CreditorCLID)
//.Select(g => new CreditorStatistics(g.FirstOrDefault()?.CreditorName, g.ToList()))
//.ToList();
_placements4 = placements.GroupBy(p => p.Community).Select(g => g.FirstOrDefault()?.Community).ToList();
//_placements5 = _placements4.Where(c=>)
}
var dagg = _placements.Select(c => new { c.Community, c.DaysLapsed }).ToList();
// public static double? GetAvgDaysLeased(this StatisticsGroup group)
//=> group.PlacementsStatistics.Where(ps => ps.HasValidMoveInOutDates && ps.DaysLeased != null).Average(ps => ps.DaysLeased);
// return placements.GroupBy(p => p.CreditorCLID)
//.Select(g => new CreditorStatistics(g.FirstOrDefault()?.CreditorName, g.ToList()))
//.ToList();
// public int DaysLapsed => MoveOutValue.HasValue ? ListedDateValue.Value.Subtract(MoveOutValue.Value).Days : 0;
var catt = JsonConvert.SerializeObject(_placements4);
return(catt);
}
//[Authorize(Roles = "Admin")]
//[Authorize(Policy = "OnlyAdminAccess")]
public string getPlacementReport(string input)
{
var _placements = new List <Placement>();
using (PlacementContext context = new PlacementContext())
{
var placements = (from s in context.Placements
//orderby s.ClientNumber
.Take(100)
select s).ToList <Placement>();
_placements = placements;
}
var catt = JsonConvert.SerializeObject(_placements);
return(catt);
}
private static SequenceNotePlacement GetPlacement(PlacementContext context)
{
if (context == null)
{
return(SequenceNotePlacement.Over);
}
if (context.LEFT_OF() != null)
{
return(SequenceNotePlacement.LeftOf);
}
if (context.RIGHT_OF() != null)
{
return(SequenceNotePlacement.RightOf);
}
throw new NotSupportedException();
}
public string getAvgDaysLapsedReport2(string input)
{
var _placements = new List <Placement>();
var _placements6 = new List <int>();
using (PlacementContext context = new PlacementContext())
{
var placements = (from s in context.Placements
//.OrderBy(s => s.DaysLapsed)
.Take(5000)
.Where(c => c.MoveInDate != null && c.MoveOutDate != null && c.ListedDate != null)
select s).ToList <Placement>();
_placements = placements;
_placements6 = _placements.Select(c => c.DaysLapsed).ToList();
}
var catt = JsonConvert.SerializeObject(_placements6);
return(catt);
}
static void Main(string[] args)
{
PlacementContext context3 = new PlacementContext();
using (PlacementContext context2 = new PlacementContext())
{
var ptx = (from r in context2.Placements select r);
var students = (from s in context2.Placements
//orderby s.ClientNumber
.Take(100)
select s).ToList <Placement>();
}
var test = context3.Placements;
using (var context = new MyContext())
{
// Create and save a new Students
Console.WriteLine("Adding new students");
var student = new Student
{
ID = 1,
FirstMidName = "Alain",
LastName = "Bomer",
//EnrollmentDate = DateTime.Parse(DateTime.Today.ToString())
};
context.Students.Add(student);
var student1 = new Student
{
ID = 2,
FirstMidName = "Mark",
LastName = "Upston",
//EnrollmentDate = DateTime.Parse(DateTime.Today.ToString())
};
context.Students.Add(student1);
//context.Entry(student).State = EntityState.Added;
context.SaveChanges();
// Display all Students from the database
var students = (from s in context.Students
orderby s.FirstMidName
select s).ToList <Student>();
Console.WriteLine("Retrieve all Students from the database:");
foreach (var stdnt in students)
{
string name = stdnt.FirstMidName + " " + stdnt.LastName;
Console.WriteLine("ID: {0}, Name: {1}", stdnt.ID, name);
}
var authors = context.Database
.SqlQuery <Student>("EXECUTE dbo.GetAllAuthors")
.ToList();
var books = context.Database
.SqlQuery <Student>("EXECUTE dbo.GetBookById 2")
.ToList();
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
Console.ReadLine();
}
}
