public static List <EmployeeLeave> GetEmployeeLeaveList(int companyId) { List <EmployeeLeave> list = new List <EmployeeLeave>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeLeaveList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeLeave employeeLeave = new EmployeeLeave(); employeeLeave.EmployeeLeaveId = Convert.ToInt32(dataReader["EmployeeLeaveId"]); employeeLeave.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeLeave.FinancialPeriodId = Convert.ToInt32(dataReader["FinancialPeriodId"]); employeeLeave.CurrentDays = Convert.ToDouble(dataReader["CurrentDays"]); employeeLeave.EntitledDays = Convert.ToDouble(dataReader["EntitledDays"]); list.Add(employeeLeave); } } return(list); }
public static EmployeeLeave GetEmployeeLeaveByEmployeeIdFinancialPeriodId(int employeeId, int financialPeriodId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeLeaveByEmployeeIdFinancialPeriodId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); db.AddOutParameter(dbCommand, "@EmployeeLeaveId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@CurrentDays", DbType.Double, 8); db.AddOutParameter(dbCommand, "@EntitledDays", DbType.Double, 8); //db.AddOutParameter(dbCommand, "@AccumulatedDays", DbType.Double, 8); db.AddOutParameter(dbCommand, "@EmployeeLeaveProjection", DbType.Double, 8); db.ExecuteNonQuery(dbCommand); EmployeeLeave employeeLeave = new EmployeeLeave(); employeeLeave.EmployeeId = employeeId; employeeLeave.FinancialPeriodId = financialPeriodId; employeeLeave.EmployeeLeaveId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeLeaveId")); employeeLeave.CurrentDays = Convert.ToDouble(db.GetParameterValue(dbCommand, "CurrentDays")); employeeLeave.EntitledDays = Convert.ToDouble(db.GetParameterValue(dbCommand, "EntitledDays")); //employeeLeave.AccumulatedDays = Convert.ToDouble(db.GetParameterValue(dbCommand, "AccumulatedDays")); employeeLeave.EmployeeLeaveProjection = Convert.ToDouble(db.GetParameterValue(dbCommand, "EmployeeLeaveProjection")); return(employeeLeave); }
public static EmployeeLeave GetAccumulatedLeaveByEmployeeId(int employeeId, int financialPeriodId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetAccumulatedLeaveByEmployeeId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); db.AddOutParameter(dbCommand, "@AccumulatedLeave", DbType.Double, 8); db.ExecuteNonQuery(dbCommand); EmployeeLeave employeeLeave = new EmployeeLeave(); employeeLeave.EmployeeId = employeeId; employeeLeave.AccumulatedLeave = Convert.ToDouble(db.GetParameterValue(dbCommand, "AccumulatedLeave")); return(employeeLeave); }