public async Task <IActionResult> ExaminerTasks(string display) { var user = db.AspNetUsers.Where(i => i.Email == User.Identity.Name).FirstOrDefault(); ViewBag.title = "Examiner tasks"; var client = new HttpClient(); var res = await client.GetAsync($"{Globals.Globals.end_point_get_assigned_tasks}?UserID={user.Email}").Result.Content.ReadAsStringAsync(); //TODO change with examiner user id db.Dispose(); AssinedTasksResponse resp = JsonConvert.DeserializeObject <AssinedTasksResponse>(res); db.Dispose(); if (string.IsNullOrEmpty(display)) { List <mTasks> tasks = new List <mTasks>(); List <mTasks> Completedtasks = new List <mTasks>(); foreach (mTasks task in resp.data.value.Where(z => z.Status == "Pending").ToList()) { tasks.Add(task); } foreach (mTasks task in resp.data.value.Where(z => z.Status == "Completed").ToList()) { Completedtasks.Add(task); } var a = 1; tasks = tasks.OrderByDescending(z => z.ExpDateofComp).ToList(); //tasks = task ViewBag.tasks = tasks; ViewBag.CompletedTasks = Completedtasks; } else if (display.Equals("CompanyApplications")) { var response = client.GetAsync($"{Globals.Globals.end_point_get_company_application}").Result.Content.ReadAsStringAsync().Result; dynamic dataa_j = JsonConvert.DeserializeObject(response); var companies = dataa_j.data.value; List <mCompanyResponse> companyApplications = JsonConvert.DeserializeObject <List <mCompanyResponse> >(companies.ToString()); List <mCompanyResponse> companiesAlloc = companyApplications.Where(s => !string.IsNullOrEmpty(s.companyInfo.Examiner) && s.companyInfo.Examiner.Equals("Examiner 1")).ToList(); //TODO replace "Examiner 1" with user examiner List <mCompanyResponse> companiesAllocated = companiesAlloc.OrderByDescending(z => z.companyInfo.Date_Of_Application).ToList(); ViewBag.CompanyApplications = companiesAllocated.OrderByDescending(z => z.companyInfo.Search_Ref).ToList(); ViewBag.Display = display; } return(View()); }
public void SaveActivity(AuditReport report) { report.Id = Guid.NewGuid(); db.AuditReport.Add(report); db.SaveChanges(); db.Dispose(); }
public async Task <IActionResult> ListAllEnquiryQuestions(bool open, bool closed) { var db = new dbContext(); var user = db.AspNetUsers.Where(i => i.Email == User.Identity.Name).FirstOrDefault(); var client = new HttpClient(); var res = await client.GetAsync($"{Globals.Globals.end_point_GetAllBillerEnquiries}?billercode={user.BillerCode}").Result.Content.ReadAsStringAsync(); db.Dispose(); dynamic json = JsonConvert.DeserializeObject(res); List <mServiceEnquiry> enqs = new List <mServiceEnquiry>(); if (json.res == "ok") { if (json.msg.ToString().Length > 5) { enqs = JsonConvert.DeserializeObject <mServiceEnquiry>(json.msg.ToString()); if (open) { enqs = enqs.Where(i => !i.isRead).ToList(); } if (closed) { enqs = enqs.Where(i => i.isRead).ToList(); } } } else { TempData["tmsg"] = "Error fetching the Enquirires"; TempData["type"] = "error"; } ViewBag.enqs = enqs; return(PartialView("_ListAllEnquiries")); }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
//**************************** Clean up Recources ************************************ protected virtual void Dispose(bool disposing) { if (disposing) { if (_dbContext != null) { _dbContext.Dispose(); _dbContext = null; } } }
public virtual void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { db.Dispose(); } this.disposed = true; } }
public async Task <IActionResult> BillerProducts(string id) { //string id = "7ea8add6-8340-405b-8d34-d4f7298eade2"; var db = new dbContext(); var user = db.AspNetUsers.Where(i => i.Email == User.Identity.Name).FirstOrDefault(); var client = new HttpClient(); var res = await client.GetAsync($"{Globals.Globals.end_point_get_name_searches_by_id}?ID={id}").Result.Content.ReadAsStringAsync(); db.Dispose(); dynamic json_data = JsonConvert.DeserializeObject(res); var data = json_data.data.value; mSearch enqs = JsonConvert.DeserializeObject <mSearch>(data.ToString()); ViewBag.data = enqs.searchInfo; ViewBag.names = enqs.SearchNames; return(PartialView("_ListBillerProducts")); }
public string generateRandomEmail() { using (var context = new dbContext()) { string randomEmailString = ""; int count = 0; while (count == 0) { randomEmailString = generateRandomString(5); count++; emailListModel emailList = new emailListModel { Email = randomEmailString, Password = randomEmailString + "007" }; bool get = context.EmailLists.Any(r => r.Email == emailList.Email); if (get) { count = 0; } } emailListModel emailListToAdd = new emailListModel { Email = randomEmailString, Password = randomEmailString + "007" }; context.EmailLists.Add(emailListToAdd); context.SaveChanges(); context.Dispose(); return(randomEmailString); } }
public void Dispose() { _context.Dispose(); }
public void Dispose() { db?.Dispose(); }
public DataBind SaveUpdateEmployee(Employee employee) { var isExist = db.Employee.Where(e => e.EmployeeId == employee.EmployeeId).ToList(); if (!isExist.Any()) { db.Employee.Add(employee); db.SaveChanges(); DataBind da = SaveUpdateUserRole(new UserRoles { RoleId = employee.RoleId, EmployeeId = employee.EmployeeId }); return(new DataBind()); } else { var databefore = db.Employee.Where(s => s.EmployeeId == employee.EmployeeId).Select(p => new { EmployeeId = p.EmployeeId, EmployeeName = p.EmployeeName, Email = p.Email, Designation = p.Designation.DesignationName, Section = p.Section.SectionName, Department = p.Section.Department.Name, JoinDate = p.JoiningDate, Location = p.Location, Role = p.Roles.FirstOrDefault().RoleName }).FirstOrDefault(); var data1 = JsonConvert.SerializeObject(databefore); db.Employee.AddOrUpdate(employee); //db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); var dataAfter = db.Employee.Where(s => s.EmployeeId == employee.EmployeeId).Select(p => new { EmployeeId = p.EmployeeId, EmployeeName = p.EmployeeName, Email = p.Email, Designation = p.Designation.DesignationName, Section = p.Section.SectionName, Department = p.Section.Department.Name, JoinDate = p.JoiningDate, Location = p.Location, Role = p.Roles.FirstOrDefault().RoleName }).FirstOrDefault(); var data2 = JsonConvert.SerializeObject(dataAfter); DataBind data = new DataBind { dataBefore = data1, dataAfter = data2 }; db.Dispose(); return(data); } }