public IEnumerable <ChartVM> RemainingQuota()
{
var _userRepo = new GeneralDapperRepository <ChartVM>(_configuration);
var result = _userRepo.Get("SP_retrieveRemainingQuota", null);
return(result);
}
public IEnumerable <ChartVM> RequestByDate()
{
var _userRepo = new GeneralDapperRepository <ChartVM>(_configuration);
var result = _userRepo.Get("SP_requestByDate", null);
return(result);
}
public IEnumerable <ChartVM> Department()
{
var _userRepo = new GeneralDapperRepository <ChartVM>(_configuration);
var result = _userRepo.Get("SP_retrieveQuotaDept", null);
return(result);
}
public IEnumerable <ChartVM> Position()
{
var _userRepo = new GeneralDapperRepository <ChartVM>(_configuration);
var result = _userRepo.Get("SP_retrieveQoutaPosition", null);
return(result);
}
public IEnumerable <RequestVM> HistoryByNIK(string nik)
{
var history = new GeneralDapperRepository <RequestVM>(_configuration);
_parameters.Add("@NIK", nik);
var result = history.Get("SP_historyRequest", _parameters);
return(result);
}
public IEnumerable <RequestVM> ActionHR()
{
var request = new GeneralDapperRepository <RequestVM>(_configuration);
_parameters.Add("@Status", 3);
var result = request.Get("SP_statusRequest", _parameters);
return(result);
}
public IEnumerable <ChartVM> TotalReasonByNIK(string NIK)
{
var userRepo = new GeneralDapperRepository <ChartVM>(_configuration);
var temp = NIK;
_parameters.Add("@NIK", temp);
var result = userRepo.Get("SP_chartEmployee", _parameters);
return(result);
}