public PayslipController(UnisolAPIdbContext context, IConfiguration configuration, IStaffServices staffServices)
{
_context = context;
_configuration = configuration;
_staffServices = staffServices;
staffUtilities = new StaffUtilities();
}
public PNineController(UnisolAPIdbContext context, IConfiguration configuration, IStaffServices staffServices, IUnitOfWork unitOfWork)
{
_context = context;
_unitOfWork = unitOfWork;
_configuration = configuration;
_staffServices = staffServices;
staffUtilities = new StaffUtilities();
}
public StaffServices(IUnitOfWork unitOfWork, IConfiguration configuration, UnisolAPIdbContext context)
{
_unitOfWork = unitOfWork;
_configuration = configuration;
staffUtilities = new StaffUtilities();
utils = new Utils(context);
_context = context;
}
public IEnumerable <string> GetAccountsAmount(IConfiguration configuration, List <string> activeAccounts, StaffUtilities staffUtilities, string month, string userCode)
{
string connetionString = DbSetting.ConnectionString(configuration, "Unisol");
SqlConnection connection = new SqlConnection(connetionString);
connection.Open();
var colString = staffUtilities.GetColumnTypes(activeAccounts);
var getAmountsSql = "SELECT " + colString + " FROM hrpSalProcess WHERE SPeriod='" + month +
"' AND EmpNo='" + userCode + "'";
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
var amountCommand = new SqlCommand(getAmountsSql, connection);
var reader = amountCommand.ExecuteReader();
var listActiveAmountOnColumns = new List <string>();
while (reader.Read())
{
activeAccounts.ForEach(column => { listActiveAmountOnColumns.Add(Convert.ToString(reader[column])); });
}
amountCommand.Dispose();
connection.Close();
return(listActiveAmountOnColumns);
}
