public async Task <IActionResult> Index() { DashboardViewModel _model = new DashboardViewModel(); using RDATContext context = new RDATContext(); List <TestingLog> activeLogs = context.TestingLogs.Where(tl => Convert.ToInt32(tl.Reported_Results) < 1).ToList(); char[] goodResults = { '1', '2', '3' }; // Get User Roles System.Security.Claims.ClaimsPrincipal currentUser = this.User; bool IsAdmin = currentUser.IsInRole("Admin"); bool IsReadOnly = currentUser.IsInRole("ReadOnly"); _model.BadgeTotalActiveDrivers = context.Drivers.Where(d => d.TerminationDate == null && !d.isDelete).Count(); _model.BadgeTotalActiveCompanies = context.Companys.Where(c => c.Status == "1" && c.isDelete != true).Count(); // context.Companys.Where(d => ??).Count(); _model.BadgeOutstandingDrugTest = activeLogs.Where(tl => tl.Test_Type == "Drug").Count(); _model.BadgeOutstandingAlcoholTest = activeLogs.Where(tl => tl.Test_Type == "Alcohol").Count(); _model.FavoriteCompanies = context.Companys.Where(c => c.isFavorite).OrderByDescending(p => p.Id).ToList(); _model.FavoriteDrivers = context.Drivers.Where(d => d.isFavorite).OrderByDescending(p => p.Id).ToList(); return(View(_model)); }
public ActionResult Edit(int id, IFormCollection collection) { try { using RDATContext context = new RDATContext(); Company _company = context.Companys.Where(c => c.Id == id).FirstOrDefault(); _company.Name = collection["Company.Name"]; _company.Phone = collection["Company.Phone"]; _company.Fax = collection["Company.Fax"]; _company.AddressLine1 = collection["Company.AddressLine1"]; _company.AddressLine2 = collection["Company.AddressLine2"]; _company.City = collection["Company.City"]; _company.State = collection["Company.State"]; _company.Zip = collection["Company.Zip"]; _company.Email = collection["Company.Email"]; _company.Dot = collection["Company.Dot"]; _company.RepresentativeName = collection["Company.RepresentativeName"]; _company.Status = collection["Company.Status"]; _company.Modified = DateTime.Now; context.Update(_company); context.SaveChanges(); // return data; return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
private bool BuildBatch(int id) { using (RDATContext context = new RDATContext()) { List <TempTestingLog> _logs = context.TempTestingLogs.ToList(); foreach (TempTestingLog log in _logs) { TestingLog _testingLog = new TestingLog(); _testingLog.Test_Type = log.Test_Type; _testingLog.Driver_Id = log.Driver_Id; _testingLog.Driver_Name = log.Driver_Name; _testingLog.Created = log.CreatedDate; _testingLog.Selectiondatealcohol = log.CreatedDate; _testingLog.Selectiondatedrug = log.CreatedDate; _testingLog.Modified = log.ModifiedDate; _testingLog.TestDate = log.CreatedDate; _testingLog.Batch_Id = id; _testingLog.Company_Id = log.Company_Id; _testingLog.Reported_Results = "0"; context.TestingLogs.Add(_testingLog); } context.SaveChanges(); return(true); } return(false); }
public IViewComponentResult Invoke(string searchTerm) { FeaturedCompaniesViewModel _model = new FeaturedCompaniesViewModel(); using RDATContext context = new RDATContext(); var my = searchTerm; try { if (searchTerm != null) { _model.Companies = context.Companys.Where(c => c.Name.Contains(searchTerm)).OrderByDescending(p => p.Id).ToList(); } else { _model.Companies = context.Companys.Where(c => c.isFavorite).OrderByDescending(p => p.Id).ToList(); } } catch (Exception) { throw; } return(View(_model)); }
public IActionResult Renewal(RenewalReportViewModel model) { RenewalReportViewModel _model = new RenewalReportViewModel(); using RDATContext context = new RDATContext(); List <Company> _co = context.Companys.ToList(); List <Driver> drivers = new List <Driver>(); _model.RenewalMonth = model.RenewalMonth; drivers = context.Drivers.Where(c => c.TerminationDate == null && c.EnrollmentDate.Value.Month == model.RenewalMonth).ToList(); var driverList = drivers.Join(_co, d => d.Company_id, co => co.Id, (driver, company) => new DriverCompanyModel { Id = driver.Id, DriverName = driver.DriverName, CompanyName = company.Name, Phone = driver.Phone, Email = driver.Email, EnrollmentDate = driver.EnrollmentDate, TerminationDate = driver.TerminationDate, isFavorite = driver.isFavorite, }).OrderBy(d => d.DriverName).ToList(); _model.Drivers = driverList; return(View(_model)); }
public ActionResult GetResults(string currentResult) { //Allowed response content format //{'E':'Letter E','F':'Letter F','G':'Letter G', 'selected':'F'} //"{'3':'Excused','2':'Negative','1':'Positive','4':'Undefined','selected': '4'}" int selectedResult = 0; if (currentResult == null) { currentResult = "Undefined"; } StringBuilder sb = new StringBuilder(); using (RDATContext context = new RDATContext()) { var results = context.Results.OrderBy(a => a.DisplayName).ToList(); foreach (var item in results) { sb.Append(string.Format("'{0}':'{1}',", item.Id, item.DisplayName)); } selectedResult = context.Results.Where(a => a.DisplayName == currentResult).First().Id; } sb.Append(string.Format("'selected':'{0}'", selectedResult)); //var _json = JsonConvert.SerializeObject("{" + sb.ToString() + "}"); //return Json(_json); return(Content("{" + sb.ToString() + "}")); }
public async Task <IActionResult> Create( [Bind("Company_id,DriverName,SSN,AddressLine1,AddressLine2,City,State,Zipcode,Location,Phone,Fax,Cell,Email,CDL")] Driver driver) { using RDATContext context = new RDATContext(); var drivers = context.Drivers; try { if (ModelState.IsValid) { driver.UniqueId = Guid.NewGuid(); driver.EnrollmentDate = DateTime.Now; drivers.Add(driver); await context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } catch (DbUpdateException /* ex */) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(View()); }
public ActionResult Create() { CreateDriverViewModel _model = new CreateDriverViewModel(); Driver _driver = new Driver(); _model.Driver = _driver; using RDATContext context = new RDATContext(); List <SelectListItem> companies = context.Companys.Where(c => c.Status == "1").OrderBy(c => c.Name).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.Name }).ToList(); _model.Companies = companies; List <SelectListItem> states = context.States.OrderBy(s => s.StateName).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.StateName }).ToList(); _model.States = states; return(View(_model)); }
public ActionResult UpdateDriver([FromBody] UpdateDriverResults results) { using RDATContext context = new RDATContext(); // Check for Drug Update //if (results != null && results.Drug_TestingLogID != 0) //{ // TestingLog _drugResults = context.TestingLogs.Where(tl => tl.Id == results.Drug_TestingLogID).FirstOrDefault(); // _drugResults.ResultsDate = results.Drug_Results_Date; // _drugResults.Reported_Results = results.Drug_Reported_Result; // context.Update(_drugResults); // context.SaveChanges(); //} // Check for Alcohol //if (results != null && results.Alcohol_TestingLogID != 0) //{ // TestingLog _alcoholResults = context.TestingLogs.Where(tl => tl.Id == results.Alcohol_TestingLogID).FirstOrDefault(); // _alcoholResults.ResultsDate = results.Alcohol_Results_Date; // _alcoholResults.Reported_Results = results.Alcohol_Reported_Result; // context.Update(_alcoholResults); // context.SaveChanges(); //} if (results == null) { // Send "false" return(Json(new { success = false, responseText = "The attached file is not supported." })); } else { // Send "Success" return(Json(new { success = true, responseText = "Your message successfuly sent!" })); } }
public IActionResult Edit(int id) { using RDATContext context = new RDATContext(); CreateDriverViewModel _model = new CreateDriverViewModel(); // Get User Roles System.Security.Claims.ClaimsPrincipal currentUser = this.User; _model.IsReadOnly = currentUser.IsInRole("ReadOnly"); Driver _driver = context.Drivers.Where(d => d.Id == id).FirstOrDefault(); ViewBag.CompanyName = _driver.DriverName; List <SelectListItem> states = context.States.OrderBy(s => s.StateName).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.StateName }).ToList(); _model.States = states; _model.Driver = _driver; return(View(_model)); }
public ActionResult Create(IFormCollection collection) { try { Company _company = new Company(); // Add Company _company.Name = collection["Company.Name"]; _company.Phone = collection["Company.Phone"]; _company.Fax = collection["Company.Fax"]; _company.AddressLine1 = collection["Company.AddressLine1"]; _company.AddressLine2 = collection["Company.AddressLine2"]; _company.City = collection["Company.City"]; _company.State = collection["Company.Zip"]; _company.Zip = collection["Company.AddressLine1"]; _company.Email = collection["Company.Email"]; _company.Created = DateTime.Now; _company.Modified = DateTime.Now; _company.isDelete = false; _company.Status = "1"; using RDATContext context = new RDATContext(); context.Companys.Add(_company); context.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult GetDriverLogs(int id) { SingleBatchViewModel _model = new SingleBatchViewModel(); using (RDATContext context = new RDATContext()) { // List<TestingLog> _logs = context.TestingLogs.Where(tl => tl.Batch_Id == BatchId).ToList(); List <BatchCompanyModel> _logs = (from tl in context.TestingLogs join c in context.Companys on tl.Company_Id equals c.Id join b in context.Batches on tl.Batch_Id equals b.Id select new BatchCompanyModel() { Id = tl.Id, Driver_Id = tl.Driver_Id, Driver_Name = tl.Driver_Name, Company_Id = tl.Company_Id, Company_Name = c.Name, Reported_Results = tl.Reported_Results, ResultsDate = tl.ResultsDate, Batch_Id = tl.Batch_Id, BatchDate = b.RunDate, ClosedDate = tl.ClosedDate, Test_Type = tl.Test_Type }).Where(tl => tl.Driver_Id == id).ToList(); foreach (BatchCompanyModel l in _logs) { l.Reported_Results = l.Reported_Results == "1" ? "Positive" : l.Reported_Results == "2" ? "Negative" : l.Reported_Results == "3" ? "Excused" : " "; } _model.TestingLogs = _logs; } return(View(_model)); }
public ActionResult DashboardCompanies() { using RDATContext context = new RDATContext(); var companys = context.Companys.OrderByDescending(p => p.Id).Take(5); return(View(companys.ToList())); }
// GET: Company public ActionResult Index(string[] args) { using RDATContext context = new RDATContext(); var companys = context.Companys; return(View(companys.ToList())); }
public ActionResult Edit(int id, IFormCollection collection) { CreateDriverViewModel _model = new CreateDriverViewModel(); Driver _driver = new Driver(); try { using RDATContext context = new RDATContext(); _driver = context.Drivers.Where(d => d.Id == id).FirstOrDefault(); _driver.DriverName = collection["Driver.DriverName"]; _driver.Phone = collection["Driver.Phone"]; _driver.Fax = collection["Driver.Fax"]; _driver.AddressLine1 = collection["Driver.AddressLine1"]; _driver.AddressLine2 = collection["Driver.AddressLine2"]; _driver.City = collection["Driver.City"]; _driver.State = collection["Driver.State"]; _driver.Zipcode = collection["Driver.Zipcode"]; _driver.Email = collection["Driver.Email"]; _driver.CDL = collection["Driver.CDL"]; _driver.Cell = collection["Driver.Cell"]; if (Int32.TryParse(collection["Driver.Company_id"], out int result)) { _driver.Company_id = Int32.Parse(collection["Driver.Company_id"]); } ; _driver.EnrollmentDate = DateTime.Parse(collection["Driver.EnrollmentDate"]); if (DateTime.TryParse(collection["Driver.TerminationDate"], out DateTime resultDate)) { _driver.TerminationDate = DateTime.Parse(collection["Driver.TerminationDate"]); } context.Update(_driver); context.SaveChanges(); // return data; return(RedirectToAction(nameof(Index))); } catch { using RDATContext context = new RDATContext(); List <SelectListItem> states = context.States.OrderBy(s => s.StateName).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.StateName }).ToList(); _model.States = states; _model.Driver = _driver; return(View(_model)); } }
public IActionResult Search(string driverName, string company, string cdl) { using RDATContext context = new RDATContext(); DriverSearchModel _model = new DriverSearchModel(); List <Driver> drivers = new List <Driver>(); if (driverName != "") { drivers = context.Drivers.Where(c => c.DriverName.Contains(driverName)).ToList(); } if (!company.IsEmpty() && company != null) { List <Company> cos = context.Companys.Where(c => c.Name.Contains(company)).ToList(); foreach (Company co in cos) { List <Driver> cosDrivers = context.Drivers.Where(d => d.Company_id == co.Id).ToList(); if (cosDrivers != null) { drivers.AddRange(cosDrivers); } } } if (!cdl.IsEmpty() && cdl != null) { List <Driver> cdlDrivers = drivers.Where(c => c.CDL.Contains(cdl)).ToList(); if (cdlDrivers != null) { drivers.AddRange(cdlDrivers); } } List <Company> _co = context.Companys.ToList(); var driverList = drivers.Join(_co, d => d.Company_id, co => co.Id, (driver, company) => new DriverCompanyModel { Id = driver.Id, DriverName = driver.DriverName, CompanyName = company.Name, Phone = driver.Phone, Email = driver.Email, EnrollmentDate = driver.EnrollmentDate, TerminationDate = driver.TerminationDate, isFavorite = driver.isFavorite, }).ToList(); var count = drivers.Count(); _model.Drivers = driverList; _model.DriverName = driverName; return(View("Index", _model)); }
// Show All Batches public IActionResult ViewBatch() { ViewBatchViewModel _model = new ViewBatchViewModel(); using (RDATContext context = new RDATContext()) { _model.Batches = context.Batches.OrderByDescending(o => o.Id).ToList(); } return(View(_model)); }
public List <SelectListItem> GetCompanies() { using RDATContext context = new RDATContext(); List <SelectListItem> companies = context.Companys.Where(c => c.isDelete == false).OrderBy(c => c.Name).Select(a => new SelectListItem { Value = a.Name, //a.Id.ToString(), Text = a.Name }).ToList(); return(companies); }
public IViewComponentResult Invoke(string searchTerm) { FeaturedDriversViewModel _model = new FeaturedDriversViewModel(); List <Driver> _drivers = new List <Driver>(); List <DriverSearchResult> _results = new List <DriverSearchResult>(); using RDATContext context = new RDATContext(); var my = searchTerm; if (searchTerm != null) { _drivers = context.Drivers.Where(d => d.DriverName.Contains(searchTerm)).OrderByDescending(p => p.Id).ToList(); } else { _drivers = context.Drivers.Where(d => d.isFavorite).OrderByDescending(p => p.Id).ToList(); } foreach (Driver d in _drivers) { string _companyName = context.Companys.Where(c => c.Id == d.Company_id).FirstOrDefault().Name; // Get latest batch - 0 is no batches exist int _latestBatchId = context.Batches.OrderByDescending(b => b.Id).FirstOrDefault() != null?context.Batches.OrderByDescending(b => b.Id).FirstOrDefault().Id : 0; // Determine if the Driver was in the last batch - check for 0 first bool _isInLatestBatch = _latestBatchId != 0 ? context.TestingLogs.Where(l => l.Batch_Id == _latestBatchId).Any(tl => tl.Driver_Id == d.Id && tl.Batch_Id == _latestBatchId) : false; // Look in any batch bool _isInAnyBatch = context.TestingLogs.Where(tl => tl.Driver_Id == d.Id && tl.ResultsDate == null).Count() > 0 ? true : false; _results.Add(new DriverSearchResult { CompanyName = _companyName, DriverName = d.DriverName, TerminationDate = d.TerminationDate, EnrollmentDate = d.EnrollmentDate, Id = d.Id, isLatestBatch = _isInAnyBatch, // _isInLatestBatch, isFavorite = d.isFavorite }); } _model.Drivers = _results; return(View(_model)); }
public IActionResult Dashboard() { DashboardViewModel _model = new DashboardViewModel(); using RDATContext context = new RDATContext(); _model.BadgeTotalActiveDrivers = context.Drivers.Count(); _model.BadgeTotalActiveCompanies = 77; // context.Companys.Where(d => ??).Count(); _model.BadgeOutstandingDrugTest = 99; _model.BadgeOutstandingAlcoholTest = 88; var companys = context.Companys.OrderByDescending(p => p.Id).Take(5); return(View(_model)); }
public ActionResult Favorite(int id) { var thisID = id; using RDATContext context = new RDATContext(); Company _company = context.Companys.Where(c => c.Id == id).FirstOrDefault(); _company.isFavorite = !_company.isFavorite; context.Update(_company); context.SaveChanges(); return(RedirectToAction(nameof(Index))); }
// GET: Company/List public ActionResult List(int id) { using RDATContext context = new RDATContext(); var companys = context.Companys; var count = companys.Count(); var tempList = new List <Company>(); var co1 = new Company(); co1.Name = "Chris"; tempList.Add(co1); return(View(tempList)); }
private bool ClearTempBatch() { try { using (RDATContext context = new RDATContext()) { List <TempTestingLog> existingEntries = context.TempTestingLogs.ToList(); context.TempTestingLogs.RemoveRange(existingEntries); context.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public IActionResult UpdateBatch(CreateBatchViewModel model) { // Create Batch Batch _batch = new Batch(); var _tempTestingLog = new List <TempTestingLog>(); using (RDATContext context = new RDATContext()) { // get list of existing test logs _tempTestingLog = context.TempTestingLogs.ToList(); // get active drivers int activeDrivers = context.Drivers.Where(d => d.TerminationDate == null && !d.isDelete).Count(); int numDrug = context.TempTestingLogs.Where(t => t.Test_Type == "Drug").Count(); int numAlcohol = context.TempTestingLogs.Where(t => t.Test_Type == "Alcohol").Count(); float _percentDrug = ((float)numDrug / activeDrivers) * 100; float _percentAlcohol = ((float)numAlcohol / activeDrivers) * 100; ViewBag.percentDrug = _percentDrug.ToString("##"); ViewBag.percentAlcohol = _percentAlcohol.ToString("##"); ViewBag.totalDrivers = numDrug + numAlcohol; ViewBag.activeDrivers = activeDrivers; // Create the Batch _batch.Created = DateTime.Now; _batch.RunDate = DateTime.Now; _batch.Alcohol_Percentage = (int)Math.Round(_percentAlcohol); _batch.Drug_Percentage = (int)Math.Round(_percentDrug); _batch.Alcohol_Tests = numAlcohol; _batch.Drug_Tests = numDrug; _batch.Eligible_Drivers = activeDrivers; context.Batches.Add(_batch); context.SaveChanges(); // Get New Batch ID int batchID = _batch.Id; // Build Batch BuildBatch(batchID); ClearTempBatch(); } return(RedirectToAction("ViewBatch", "Reports")); }
public JsonResult GetCompanies() { using RDATContext context = new RDATContext(); var companys = context.Companys; string json = JsonConvert.SerializeObject(companys); var count = companys.Count(); var w = new GridData() { data = json, itemsCount = count }; string data = JsonConvert.SerializeObject(w); // return data; return(Json(json)); }
public IActionResult GetActiveDriversByCompany(int companyId) { using RDATContext context = new RDATContext(); var activeDrivers = context.Drivers.Where(d => d.TerminationDate == null && d.Company_id == companyId); string json = JsonConvert.SerializeObject(activeDrivers); var count = activeDrivers.Count(); var w = new GridData() { data = json, itemsCount = count }; string data = JsonConvert.SerializeObject(w); // return data; return(View(json)); }
public ActionResult Create() { CreateCompanyViewModel _model = new CreateCompanyViewModel(); Company _company = new Company(); _model.Company = _company; using RDATContext context = new RDATContext(); List <SelectListItem> states = context.States.OrderBy(s => s.StateName).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.StateName }).ToList(); _model.States = states; return(View(_model)); }
public ActionResult Edit(int id) { using RDATContext context = new RDATContext(); CreateCompanyViewModel _model = new CreateCompanyViewModel(); Company _company = context.Companys.Where(c => c.Id == id).FirstOrDefault(); ViewBag.CompanyName = _company.Name; List <SelectListItem> states = context.States.OrderBy(s => s.StateName).Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.StateName }).ToList(); _model.States = states; _model.Company = _company; // return data; return(View(_model)); }
public ActionResult Favorite(int id) { var thisID = id; using RDATContext context = new RDATContext(); try { Driver _driver = context.Drivers.Where(c => c.Id == id).FirstOrDefault(); _driver.isFavorite = !_driver.isFavorite; context.Update(_driver); context.SaveChanges(); } catch (Exception) { throw; } return(RedirectToAction(nameof(Index))); }
public UpdateDriverResults GetDriver(int id) { var thisID = id; using RDATContext context = new RDATContext(); UpdateDriverResults _driverResults = new UpdateDriverResults(); Driver _driver = context.Drivers.Where(c => c.Id == id).FirstOrDefault(); int _batchId = context.Batches.OrderByDescending(b => b.Id).FirstOrDefault().Id; // Get TestingLog // TODO: Create List of Alcohol Dates - There can be multiples List <TestingLog> _logDrug = context.TestingLogs.Where(l => l.Driver_Id == id && l.Test_Type == "Drug" && l.ResultsDate == null).ToList(); // TODO: Create List of Alcohol Dates - There can be multiples List <TestingLog> _logAlcohol = context.TestingLogs.Where(l => l.Driver_Id == id && l.Test_Type == "Alcohol" && l.ResultsDate == null).ToList(); // Set Values _driverResults.Driver_Id = _driver.Id; _driverResults.Driver_Name = _driver.DriverName; _driverResults.Company_Name = context.Companys.Where(c => c.Id == _driver.Company_id).FirstOrDefault().Name; _driverResults.Driver_UniqueID = _driver.UniqueId.ToString(); // Do we have results _driverResults.Alcohol_Show = _logAlcohol.Count > 0 ? true : false; _driverResults.Drug_Show = _logDrug.Count > 0 ? true : false; // Alcohol Test if (_logAlcohol.Count > 0) { List <AlcoholResult> results = new List <AlcoholResult>(); foreach (TestingLog tl in _logAlcohol) { AlcoholResult alcoholResult = new AlcoholResult(); alcoholResult.Alcohol_TestingLogID = tl.Id; alcoholResult.Alcohol_Test_Date = tl.TestDate; alcoholResult.Alcohol_Specimen_Id = tl.Specimen_Id; alcoholResult.Alcohol_Results_Date = tl.ResultsDate; alcoholResult.Alcohol_Reported_Result = tl.Reported_Results; alcoholResult.BatchID = tl.Batch_Id; results.Add(alcoholResult); } _driverResults.AlcoholResults = results; } // Drug Test if (_logDrug.Count > 0) { List <DrugResult> dresults = new List <DrugResult>(); foreach (TestingLog tl in _logDrug) { DrugResult drugResult = new DrugResult(); drugResult.Drug_TestingLogID = tl.Id; drugResult.Drug_Test_Date = tl.TestDate; drugResult.Drug_Specimen_Id = tl.Specimen_Id; drugResult.Drug_Results_Date = tl.ResultsDate; drugResult.Drug_Reported_Result = tl.Reported_Results; drugResult.BatchID = tl.Batch_Id; dresults.Add(drugResult); } _driverResults.DrugResults = dresults; } return(_driverResults); }