public ActionResult EmployeeTimeSheet(EmployeeTimeSheet model)
{
var selectedtimeSheetData = new List <SelectedTimeSheet>();
try
{
//int uid = int.Parse(Session["UserID"].ToString());
int pid = Convert.ToInt32(model.ProjectName);
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
selectedtimeSheetData = (from data in dbHrms.TimesheetDatas
join
userdata in dbHrms.Users on data.UserID equals userdata.UserID
join
projectdata in dbHrms.Projects on data.ProjectID equals projectdata.ProjectID
where data.UserID == model.EmployeeId && data.ProjectID == pid && EntityFunctions.TruncateTime(data.DateOFSheet) >= model.StartDate && EntityFunctions.TruncateTime(data.DateOFSheet) <= model.EndDate
select new SelectedTimeSheet()
{
EmployeeName = ((userdata.FirstName) + " " + (userdata.LastName ?? "")).Trim(),
ProjectName = projectdata.ProjectName,
Date = data.DateOFSheet,
ProjectId = data.ProjectID,
UserId = data.UserID
}).ToList();
return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet));
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet));
}
public void Update(EmployeeTimeSheet time)
{
PayrollDataContext context = new PayrollDataContext();
var timesheet = context.EmployeeTimeSheets.Where(x => x.Id == time.Id).FirstOrDefault();
timesheet.ReportedDate = time.ReportedDate;
timesheet.DateTimeIn = time.DateTimeIn;
timesheet.DateTimeOut = time.DateTimeOut;
context.SubmitChanges();
}
public Guid Create(EmployeeTimeSheet time)
{
PayrollDataContext context = new PayrollDataContext();
if (time.Id == Guid.Empty)
time.Id = Guid.NewGuid();
time.IsDeleted = false;
context.EmployeeTimeSheets.InsertOnSubmit(time);
context.SubmitChanges();
return time.Id;
}
//
// GET: /EmployeeTimeSheet/
public ActionResult EmployeeTimeSheet()
{
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
EmployeeTimeSheet obj = new EmployeeTimeSheet();
try
{
obj.ProjectNames = GetProjects();
obj.EmployeeNames = new List <SelectListItem>();
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(obj));
}
}
