C# (CSharp) HBM.GeneralManagement RatePlans 예제들

예제 #1

파일: RatePlansDAO.cs 프로젝트: nirshandileep/HotelManagement

        public DataSet SelectAll(RatePlans ratePlan)
        {
            Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand dbCommand = db.GetStoredProcCommand("usp_RatePlansSelectAll");
            db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, ratePlan.CompanyId);

            return db.ExecuteDataSet(dbCommand);
        }

예제 #2

파일: RatePlansDAO.cs 프로젝트: Jolayemisamuel/HotelManagement-1

        public DataSet SelectAll(RatePlans ratePlan)
        {
            Database  db        = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand dbCommand = db.GetStoredProcCommand("usp_RatePlansSelectAll");

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

            return(db.ExecuteDataSet(dbCommand));
        }

예제 #3

파일: RatePlansDAO.cs 프로젝트: nirshandileep/HotelManagement

        public bool IsDuplicateTypeName(RatePlans ratePlan)
        {
            bool result = false;

            Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand dbCommand = db.GetStoredProcCommand("usp_RatePlansIsDuplicateTypeName");
            db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, ratePlan.CompanyId);
            db.AddInParameter(dbCommand, "@RatePlansId", DbType.Int32, ratePlan.RatePlansId);
            db.AddInParameter(dbCommand, "@RatePlanName", DbType.String, ratePlan.RatePlanName);
            db.AddOutParameter(dbCommand, "@IsExist", DbType.Boolean, 1);

            db.ExecuteNonQuery(dbCommand);

            result = Convert.ToBoolean(db.GetParameterValue(dbCommand, "@IsExist").ToString());

            return result;
        }

예제 #4

파일: RatePlansDAO.cs 프로젝트: Jolayemisamuel/HotelManagement-1

        public bool IsDuplicateTypeName(RatePlans ratePlan)
        {
            bool result = false;

            Database  db        = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand dbCommand = db.GetStoredProcCommand("usp_RatePlansIsDuplicateTypeName");

            db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, ratePlan.CompanyId);
            db.AddInParameter(dbCommand, "@RatePlansId", DbType.Int32, ratePlan.RatePlansId);
            db.AddInParameter(dbCommand, "@RatePlanName", DbType.String, ratePlan.RatePlanName);
            db.AddOutParameter(dbCommand, "@IsExist", DbType.Boolean, 1);

            db.ExecuteNonQuery(dbCommand);

            result = Convert.ToBoolean(db.GetParameterValue(dbCommand, "@IsExist").ToString());


            return(result);
        }