public static List <EmployeeExpenseType> GetEmployeeExpenseTypeListByEmployeeId(int employeeId)
        {
            List <EmployeeExpenseType> list = new List <EmployeeExpenseType>();

            Database  db         = DatabaseFactory.CreateDatabase("Spar-StoreRep");
            string    sqlCommand = "GetEmployeeExpenseTypeListByEmployeeId";
            DbCommand dbCommand  = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId);

            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    EmployeeExpenseType employeeExpenseType = new EmployeeExpenseType();
                    employeeExpenseType.EmployeeId = employeeId;
                    employeeExpenseType.EmployeeExpenseTypeLinkId = Convert.ToInt32(dataReader["EmployeeExpenseTypeLinkId"]);
                    employeeExpenseType.EmployeeExpenseTypeId     = Convert.ToInt32(dataReader["EmployeeExpenseTypeId"]);
                    employeeExpenseType.Description = dataReader["Description"].ToString();
                    employeeExpenseType.GlCode      = dataReader["GlCode"].ToString();
                    employeeExpenseType.ExpenseDate = Convert.ToDateTime(dataReader["ExpenseDate"]);
                    employeeExpenseType.Detail      = dataReader["Detail"].ToString();
                    employeeExpenseType.Comment     = dataReader["Comment"].ToString();
                    employeeExpenseType.Amount      = Convert.ToDecimal(dataReader["Amount"]);
                    employeeExpenseType.Budget      = Convert.ToDecimal(dataReader["Budget"]);

                    list.Add(employeeExpenseType);
                }
            }
            return(list);
        }
        public static EmployeeExpenseType GetEmployeeExpenseTypeLinkByEmployeeExpenseTypeLinkId(int employeeExpenseTypeLinkId)
        {
            Database  db         = DatabaseFactory.CreateDatabase("Spar-StoreRep");
            string    sqlCommand = "GetEmployeeExpenseTypeLinkByEmployeeExpenseTypeLinkId";
            DbCommand dbCommand  = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "@EmployeeExpenseTypeLinkId", DbType.Int32, employeeExpenseTypeLinkId);
            db.AddOutParameter(dbCommand, "@EmployeeExpenseTypeId", DbType.Int32, 4);
            db.AddOutParameter(dbCommand, "@EmployeeId", DbType.Int32, 4);
            db.AddOutParameter(dbCommand, "@ExpenseDate", DbType.DateTime, 8);
            db.AddOutParameter(dbCommand, "@Detail", DbType.String, 200);
            db.AddOutParameter(dbCommand, "@Comment", DbType.String, 8000);
            db.AddOutParameter(dbCommand, "@Amount", DbType.Double, 4);
            db.AddOutParameter(dbCommand, "@Budget", DbType.Double, 4);

            db.ExecuteNonQuery(dbCommand);
            EmployeeExpenseType employeeExpenseTypeLink = new EmployeeExpenseType();

            employeeExpenseTypeLink.EmployeeExpenseTypeLinkId = employeeExpenseTypeLinkId;
            employeeExpenseTypeLink.EmployeeExpenseTypeId     = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeExpenseTypeId"));
            employeeExpenseTypeLink.EmployeeId  = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeId"));
            employeeExpenseTypeLink.ExpenseDate = Convert.ToDateTime(db.GetParameterValue(dbCommand, "ExpenseDate"));
            employeeExpenseTypeLink.Detail      = db.GetParameterValue(dbCommand, "Detail").ToString();
            employeeExpenseTypeLink.Comment     = db.GetParameterValue(dbCommand, "Comment").ToString();
            employeeExpenseTypeLink.Amount      = Convert.ToDecimal(db.GetParameterValue(dbCommand, "Amount"));
            employeeExpenseTypeLink.Budget      = Convert.ToDecimal(db.GetParameterValue(dbCommand, "Budget"));

            return(employeeExpenseTypeLink);
        }
        public static List <EmployeeExpenseType> GetEmployeeExpenseTypeListByCompanyId(int companyId)
        {
            List <EmployeeExpenseType> list = new List <EmployeeExpenseType>();

            Database  db         = DatabaseFactory.CreateDatabase("Spar-StoreRep");
            string    sqlCommand = "GetEmployeeExpenseTypeListByCompanyId";
            DbCommand dbCommand  = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId);

            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    EmployeeExpenseType employeeExpenseType = new EmployeeExpenseType();
                    employeeExpenseType.EmployeeExpenseTypeId = Convert.ToInt32(dataReader["EmployeeExpenseTypeId"]);
                    employeeExpenseType.Description           = dataReader["Description"].ToString();
                    employeeExpenseType.GlCode = dataReader["GlCode"].ToString();

                    list.Add(employeeExpenseType);
                }
            }
            return(list);
        }