C# (CSharp) HBM.GeneralManagement Gaurantee Examples

Example #1

File: GauranteeDAO.cs Project: nirshandileep/HotelManagement

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

            return db.ExecuteDataSet(dbCommand);
        }

Example #2

File: GauranteeDAO.cs Project: Jolayemisamuel/HotelManagement-1

        public DataSet SelectAll(Gaurantee gaurantee)
        {
            Database  db        = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand dbCommand = db.GetStoredProcCommand("usp_GuaranteeSelectAll");

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

            return(db.ExecuteDataSet(dbCommand));
        }

Example #3

File: GauranteeDAO.cs Project: nirshandileep/HotelManagement

        public bool Delete(Gaurantee gaurantee)
        {
            Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand command = db.GetStoredProcCommand("usp_GuaranteeDelete");

            db.AddInParameter(command, "@GuaranteeId", DbType.Int32, gaurantee.GuaranteeId);

            db.ExecuteNonQuery(command);

            return true;
        }

Example #4

File: GauranteeDAO.cs Project: Jolayemisamuel/HotelManagement-1

        public bool Delete(Gaurantee gaurantee)
        {
            Database  db      = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand command = db.GetStoredProcCommand("usp_GuaranteeDelete");

            db.AddInParameter(command, "@GuaranteeId", DbType.Int32, gaurantee.GuaranteeId);

            db.ExecuteNonQuery(command);

            return(true);
        }

Example #5

File: GauranteeDAO.cs Project: nirshandileep/HotelManagement

        public bool Insert(Gaurantee gaurantee)
        {
            Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand command = db.GetStoredProcCommand("usp_GuaranteeInsert");

            db.AddInParameter(command, "@CompanyId", DbType.Int32, gaurantee.CompanyId);
            db.AddInParameter(command, "@GuaranteeName", DbType.String, gaurantee.GuaranteeName);
            db.AddInParameter(command, "@GuaranteeDescription", DbType.String, gaurantee.GuaranteeDescription);
            db.AddInParameter(command, "@CreatedBy", DbType.Int32, gaurantee.CreatedBy);
            db.AddInParameter(command, "@CreatedDate", DbType.DateTime, gaurantee.CreatedDate);

            db.ExecuteNonQuery(command);

            return true;
        }

Example #6

File: GauranteeDAO.cs Project: Jolayemisamuel/HotelManagement-1

        public bool Insert(Gaurantee gaurantee)
        {
            Database  db      = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand command = db.GetStoredProcCommand("usp_GuaranteeInsert");

            db.AddInParameter(command, "@CompanyId", DbType.Int32, gaurantee.CompanyId);
            db.AddInParameter(command, "@GuaranteeName", DbType.String, gaurantee.GuaranteeName);
            db.AddInParameter(command, "@GuaranteeDescription", DbType.String, gaurantee.GuaranteeDescription);
            db.AddInParameter(command, "@CreatedBy", DbType.Int32, gaurantee.CreatedBy);
            db.AddInParameter(command, "@CreatedDate", DbType.DateTime, gaurantee.CreatedDate);

            db.ExecuteNonQuery(command);

            return(true);
        }