public RegistrationViewDetailsModel GetAdminDetailsByRegistrationID(int?RegistrationID)
{
using (var _context = new DatabaseContext())
{
string RoleCode = "Manager";
var queryResult = (from registration in _context.Registration
join role in _context.Role on registration.RoleID equals role.RoleID
where registration.RegistrationID == RegistrationID && role.RoleCode == RoleCode
select registration).FirstOrDefault();
if (queryResult != null)
{
var objRegistrationViewDetailsModel = new RegistrationViewDetailsModel()
{
Birthdate = Convert.ToString(queryResult.Birthdate),
DateofLeaving = Convert.ToString(queryResult.DateofLeaving),
DateofJoining = Convert.ToString(queryResult.DateofLeaving),
EmailID = queryResult.EmailID,
EmployeeID = queryResult.EmployeeID,
Gender = queryResult.Gender,
IsActive = Convert.ToBoolean(queryResult.IsActive),
Mobileno = queryResult.Mobileno,
FullName = TimeSheetHelper.GetFullName(queryResult.FirstName, queryResult.MiddleName, queryResult.LastName),
RegistrationID = queryResult.RegistrationID,
RoleID = Convert.ToInt32(queryResult.RoleID),
Username = queryResult.Username
};
return(objRegistrationViewDetailsModel);
}
return(new RegistrationViewDetailsModel());
}
}
public List <TimeSheetOverviewModel> GetTimeSheetModels()
{
try
{
var helper = new TimeSheetHelper(this);
return(helper.BuildTimeSheetOverViewModel(this.GetUserId()));
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(null);
}
}
public string GetUsernamebyRegistrationID(int RegistrationID)
{
using (DatabaseContext _context = new DatabaseContext())
{
var employee = (from registration in _context.Registration
where registration.RegistrationID == RegistrationID
select registration).FirstOrDefault();
if (employee != null)
{
return(TimeSheetHelper.GetFullName(employee.FirstName, employee.MiddleName, employee.LastName));
}
else
{
return("");
}
}
}
public IActionResult ManageTimeSheet(string successMsg, string errorMsg)
{
var departmentService = this.GetService <DepartmentService>();
this.BuildHeaderMsg(successMsg, errorMsg);
var userIds = departmentService.GetSubordinatesByUserId(this.GetUserId());
//去掉Admin
var adminIds = this.GetService <UserService>().Get().Where(o => o.UserType == UserType.Admin).Select(o => o.Id).ToList();
userIds = userIds.Except(adminIds).ToList();
var helper = new TimeSheetHelper(this);
ViewData["UserWeeks"] = helper.BuildUserTimeSheetOverViewModels(userIds);
return(View());
}
public Dictionary <string, List <TimeSheetOverviewModel> > GetManageTimeSheetModel()
{
try
{
//var helper = new TimeSheetHelper(this);
//return helper.BuildTimeSheetOverViewModel(this.GetUserId());
var userIds = this.GetService <DepartmentService>().GetSubordinatesByUserId(this.GetUserId());
var adminIds = this.GetService <UserService>().Get().Where(o => o.UserType == UserType.Admin).Select(o => o.Id).ToList();
var internalIds = this.GetService <UserService>().Get().Where(o => o.AccountType == AccountType.Internal).Select(o => o.Id).ToList();
userIds = userIds.Except(adminIds).Except(internalIds).ToList();
var helper = new TimeSheetHelper(this);
return(helper.BuildUserTimeSheetOverViewModels(userIds));
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(null);
}
}
//
// GET: /Payroll/TimeSheet/
public ActionResult GetTimeSheets(string c, string co)
{
var model = TimeSheetHelper.Search(c, co);
return(Json(model, JsonRequestBehavior.AllowGet));
}
