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); }