public ActionResult GetProjectDetails([DataSourceRequest] DataSourceRequest request, ProjectInvolvementPercentageModel model, int employeeId)
{
// ViewBag.EmployeeList = DropdownList.EmployeeList();
try
{
List <ProjectInvolvementPercentageModel> GetDetails = GetEmployeeCurrentInvolvement(employeeId);
DataSourceResult result = GetDetails.ToDataSourceResult(request);
return(Json(result));
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
throw ex;
}
}
public ActionResult GetProjectHistoryDetails([DataSourceRequest] DataSourceRequest request, ProjectInvolvementPercentageModel model, int employeeId)
{
// ViewBag.EmployeeList = DropdownList.EmployeeList();
try
{
var list = (from x in DB.ProjectEmployee
join y in DB.ProjectMaster on x.ProjectID equals y.ProjectID
join z in DB.AuditTimeSheetInfo on x.ProjectID equals z.tablePK
where x.EmployeeID == employeeId && z.tableName == "T_TS_ProjectEmployees" &&
z.LastUpdatedUser == employeeId.ToString()
orderby z.AuditDate descending
select new
{
ProjectId = x.ProjectID,
x.EmployeeID,
y.ProjectName,
StartDate = z.startOldValue,
EndDate = z.endOldValue,
InvolvePercent = z.oldValue,
z.AuditDate
}).ToList();
List <ProjectInvolvementPercentageModel> GetDetails = new List <ProjectInvolvementPercentageModel>();
foreach (var item in list)
{
GetDetails.Add(new ProjectInvolvementPercentageModel()
{
ProjectId = item.ProjectId,
EmployeeID = item.EmployeeID,
ProjectName = item.ProjectName,
StartDate = item.StartDate,
EndDate = item.EndDate,
InvolvePercent = Convert.ToDecimal(item.InvolvePercent),
AuditDate = item.AuditDate
});
}
List <ProjectInvolvementPercentageModel> expireProjects = (from x in DB.ProjectEmployee
join y in DB.ProjectMaster
on x.ProjectID equals y.ProjectID
where x.EmployeeID == employeeId && y.EndDate < DateTime.Now
select new ProjectInvolvementPercentageModel()
{
ProjectId = x.ProjectID,
EmployeeID = x.EmployeeID,
ProjectName = y.ProjectName,
StartDate = x.StartDate,
EndDate = x.EndDate,
AuditDate = x.ModifiedDate,
InvolvePercent = x.InvPercentage.Value
}
).ToList();
GetDetails.Concat(expireProjects);
for (int i = 1; i <= GetDetails.Count(); i++)
{
GetDetails[i - 1].ItemNo = i;
}
DataSourceResult result = GetDetails.OrderBy(x => x.ItemNo).ToDataSourceResult(request);
return(Json(result));
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
throw ex;
}
}
public ActionResult EditEmpDetails([DataSourceRequest] DataSourceRequest request, IEnumerable <ProjectInvolvementPercentageModel> employees, ProjectInvolvementPercentageModel griditems)
{
// ViewBag.EmployeeList = DropdownList.EmployeeList();
try
{
long empid = 0;
foreach (ProjectInvolvementPercentageModel item in employees)
{
empid = item.EmployeeID;
DateTime?startDate = null;
if (item.StartDate.HasValue)
{
startDate = Convert.ToDateTime(item.StartDate.Value);
}
DateTime?endDate = null;
if (item.EndDate.HasValue)
{
endDate = Convert.ToDateTime(item.EndDate.Value);
}
ProjectEmployeesModel existing = DB.ProjectEmployee.FirstOrDefault(x => x.EmployeeID == item.EmployeeID && x.ProjectID == item.ProjectId);//&& x.StartDate == startDate && x.EndDate == endDate
if (existing != null)
{
existing.StartDate = startDate;
existing.EndDate = endDate;
existing.InvPercentage = item.InvolvePercent;
DB.ProjectEmployee.Attach(existing);
DB.Entry(existing).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
}
}
List <ProjectInvolvementPercentageModel> GetDetails = DB.Database.SqlQuery <ProjectInvolvementPercentageModel>(
@"exec " + Constants.P_GetMasterListOfTotalProjectInvolvement + " @empID",
new object[] {
new SqlParameter("@empID", empid)
}).ToList();
DataSourceResult result = employees.ToDataSourceResult(request);
return(Json(result));
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
throw ex;
}
}
