public async Task <object> GetEmployeeDetails(string email)
{
inv_msemployeeContext db = new inv_msemployeeContext();
var currentEmployee = await db.AmPune.SingleAsync(a => a.Email == email);
var deskDetails = await db.DeskAllocationDetails.SingleAsync(a => a.VId == currentEmployee.Gpmvid);
var gpmDetails = await db.Gpmmaster.SingleAsync(a => a.Vid == currentEmployee.Gpmvid);
object result = new {
currentEmployee.Name,
currentEmployee.Email,
currentEmployee.Id,
currentEmployee.Location,
deskDetails.AssetType,
deskDetails.GPM,
deskDetails.MachineNo,
deskDetails.ProjectName,
deskDetails.SeatNo,
deskDetails.MsReportingManager,
gpmDetails.Gpmname,
};
return(result);
}
public IEnumerable <EmployeeData> WeatherForecasts()
{
//var rng = new Random();
//return Enumerable.Range(1, 5).Select(index => new WeatherForecast
//{
// DateFormatted = DateTime.Now.AddDays(index).ToString("d"),
// TemperatureC = rng.Next(-20, 55),
// Summary = Summaries[rng.Next(Summaries.Length)]
//});
inv_msemployeeContext cont = new inv_msemployeeContext();
return(cont.EmployeeData.ToList());
}
public async Task <object> GetEmployeeDetails(string email)
{
inv_msemployeeContext db = new inv_msemployeeContext();
var currentEmployee = await db.AmPune.SingleAsync(a => a.Email == email);
int EmpID = Convert.ToInt32(currentEmployee.Id);
var deskDetails = await db.DeskAllocationDetails.SingleAsync(a => a.VId == currentEmployee.Gpmvid);
var gpmDetails = await db.Gpmmaster.SingleAsync(a => a.Vid == currentEmployee.Gpmvid);
var competencyDetails = await tb.TFactorData.Where(a => a.EmpID == EmpID).ToListAsync();
List <string> competencies = new List <string>();
foreach (TFactor_Competency_Backup comp in competencyDetails)
{
competencies.Add(comp.TFactor_Category);
}
object result = new {
currentEmployee.Name,
currentEmployee.Email,
currentEmployee.Id,
currentEmployee.Location,
deskDetails.AssetType,
deskDetails.GPM,
deskDetails.MachineNo,
deskDetails.ProjectName,
deskDetails.SeatNo,
deskDetails.MsReportingManager,
gpmDetails.Gpmname,
competencies
};
return(result);
}