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);
}
}