// GET: Schedule
public ActionResult Index()
{
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
List <Domain.ScheduleBlock> Blocks = db.ScheduleBlocks.Take(1500).ToList();
foreach (Domain.ScheduleBlock block in Blocks)
{
}
return(View(Blocks));
}
public ActionResult GetQualifiedEmployeesTable(string bench)
{
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
List <Qualification> qualifications = db.Qualifications.Where(c => c.bench.Description == bench).ToList();
List <QualifiedEmployee> employees = new List <QualifiedEmployee>();
List <Employee> emps = new List <Employee>();
foreach (Qualification q in qualifications)
{
emps.Add(q.employee);
}
return(PartialView(emps));
}
public ActionResult GetQualifiedEmployees(string bench)
{
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
List <Qualification> qualifications = db.Qualifications.Where(c => c.bench.Description == bench).ToList();
List <QualifiedEmployee> employees = new List <QualifiedEmployee>();
foreach (Qualification q in qualifications)
{
employees.Add(new QualifiedEmployee {
FirstName = q.employee.FirstName, Id = q.employee.Id, LastName = q.employee.LastName
});
}
return(Json(employees, JsonRequestBehavior.AllowGet));
}
// GET: Qualifications
public ActionResult Index()
{
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
LabScheduler2.BLL.LabRepository repo = new BLL.LabRepository(db);
List <LabScheduler2.Web.Models.QualificationsListViewModel> vm = new List <Models.QualificationsListViewModel>();
foreach (Bench _bench in repo.GetAllBenches())
{
vm.Add(new Models.QualificationsListViewModel {
bench = _bench, qualifications = _bench.Qualifications
});
}
return(View(vm));
}
public ActionResult Today()
{
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
int intMonth = DateTime.Today.Month;
int intDay = DateTime.Today.Day;
int intYear = DateTime.Today.Year;
List <Domain.ScheduleBlock> Blocks = db.ScheduleBlocks.Where(c => c.Hour.Day == intDay && c.Hour.Month == intMonth && c.Hour.Year == intYear).ToList();
foreach (Domain.ScheduleBlock block in Blocks)
{
}
return(View("Index", Blocks));
}
static void Main(string[] args)
{
// System.Data.SqlClient.SqlConnectionStringBuilder bui = new System.Data.SqlClient.SqlConnectionStringBuilder();
// string providerName = "System.Data.SqlClient";
// string serverName = ".";
// string dataBaseName = "LabManager.DAL.LabContext";
// SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
// sqlBuilder.DataSource = serverName;
// sqlBuilder.InitialCatalog = dataBaseName;
// sqlBuilder.IntegratedSecurity = true;
// string providerString = sqlBuilder.ToString();
// EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
// entityBuilder.Provider = providerName;
// entityBuilder.ProviderConnectionString = providerString;
// entityBuilder.Metadata = @"res://*/LabContext.csdl|
// res://*/LabContext.ssdl|
// res://*/LabContext.msl";
// using (EntityConnection conn =
//new EntityConnection(entityBuilder.ToString()))
// {
// conn.Open();
// Console.WriteLine("Just testing the connection.");
// conn.Close();
// }
// Console.ReadLine();
//throw new NotImplementedException();
LabManager.DAL.LabContext db = new LabManager.DAL.LabContext();
//LabScheduler2.BLL.LabRepository repo = new BLL.LabRepository(db);
//List<Qualification> qs = db.Qualifications.ToList();
//db.Qualifications.RemoveRange(qs);
//db.SaveChanges();
List <Qualification> qualifications = new List <Qualification>();
foreach (Qualification q in db.Qualifications.ToList())
{
Console.WriteLine(q.employee.FirstName);
Console.WriteLine(q.bench.Description);
Console.ReadLine();
}
throw new NotImplementedException();
Console.WriteLine("S");
Console.ReadLine();
foreach (Bench _bench in db.Benches.ToList())
{
Console.WriteLine(_bench.Description);
if (_bench.Description.Contains("Sysmex") == true)
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
db.SaveChanges();
}
if (_bench.Description == "Diffs")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "Variant")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Evelyn").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "Coag")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "ESR")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Evelyn").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "Centaur")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "UA")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Evelyn").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "Sypigg")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "IFOB")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "Vista")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jerry").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Tony").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
if (_bench.Description == "VIT D")
{
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Evelyn").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Imelda").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Jan").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Maribeth").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Marita").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Michelle").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Nirali").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Violeta").FirstOrDefault(), Status = QualificationStatus.Qualified
});
_bench.Qualifications.Add(new Qualification {
bench = _bench, employee = db.HourlyEmployees.Where(c => c.FirstName == "Wilberto").FirstOrDefault(), Status = QualificationStatus.Qualified
});
}
}
db.SaveChanges();
throw new NotImplementedException();
//List<ScheduleBlock> blocks = repo.GetAllScheduleBlocks().ToList();
//foreach(ScheduleBlock b in blocks)
//{
// Console.WriteLine(b.Bench.Description);
// Console.WriteLine(b.Hour.ToLongDateString());
// Console.ReadLine();
//}
//Console.ReadLine();
//int counter = db.ScheduleBlocks.Where(c => c.Hour.Year != 2016).Count();
//for (int i = 0; i < 100; i++)
//{
// foreach (ScheduleBlock block in db.ScheduleBlocks.Where(c => c.Hour.Year != 2016).Take(5000))
// {
// if (block.Hour.Year != 2016)
// {
// int adj = block.Hour.Year - 2016;
// adj = adj * -1;
// block.Hour = block.Hour.AddYears(adj);
// Console.WriteLine(counter);
// counter -= 1;
// }
// }
// db.SaveChanges();
//}
//Console.WriteLine("DONE");
//Console.ReadLine();
//throw new NotImplementedException();
//DateTime dt = new DateTime(2016, 1, 1,0,0,0);
//Console.WriteLine(dt.TimeOfDay.ToString());
//foreach (Bench bench in db.Benches.Where(c=>c.Id > 44).OrderBy(c=>c.Id).ToList())
//{
// for (var v = 1; v < 8761; v++)
// {
// Console.WriteLine(dt.Day.ToString());
// Console.WriteLine(dt.Month.ToString());
// Console.WriteLine(dt.Year.ToString());
// Console.WriteLine(dt.Hour.ToString());
// // Console.WriteLine(dt.Date.Date.ToLongTimeString());
// Console.WriteLine(bench.Description);
// ScheduleBlock block = new ScheduleBlock();
// block.Bench = bench;
// block.Hour = dt;
// db.ScheduleBlocks.Add(block);
// dt = dt.AddHours(1.0);
// }
// Console.WriteLine(db.SaveChanges().ToString());
//}
//Console.WriteLine("DONE");
//Console.ReadLine();
// Console.WriteLine(dt.Date.Date.ToString());
//foreach (Bench bench in db.Benches.ToList())
//{
// for (var i = 0; i < 366; i++)
// {
// for (var y = 1; y < 25; y++)
// {
// ScheduleBlock block = new ScheduleBlock();
// // block.Hour.Start = dt.
// }
// }
//}
//int x = db.SaveChanges();
//Console.WriteLine(x.ToString());
//Console.ReadLine();
}
