HBM.GeneralManagement.RoomDAO.DashboardUpdateDirtyRooms C# (CSharp) Method

DashboardUpdateDirtyRooms() public method

public DashboardUpdateDirtyRooms ( DataSet dsDirtyRooms ) : bool
dsDirtyRooms System.Data.DataSet
return bool
        public bool DashboardUpdateDirtyRooms(DataSet dsDirtyRooms)
        {
            Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
            DbCommand commandUpdate = db.GetStoredProcCommand("usp_Dashboard_RoomDirtyUpdate");

            db.AddInParameter(commandUpdate, "@RoomId", DbType.Int32, "RoomId", DataRowVersion.Current);
            db.AddInParameter(commandUpdate, "@UpdatedUser", DbType.Int32, "UpdatedUser", DataRowVersion.Current);
            db.AddInParameter(commandUpdate, "@IsDirty", DbType.Boolean, "IsDirty", DataRowVersion.Current);
            db.AddInParameter(commandUpdate, "@CleaningNote", DbType.String, "CleaningNote", DataRowVersion.Current);
            db.AddInParameter(commandUpdate, "@CleanedBy", DbType.Int32, "CleanedBy", DataRowVersion.Current);
            db.AddInParameter(commandUpdate, "@CleanedDate", DbType.DateTime, "CleanedDate", DataRowVersion.Current);

            db.UpdateDataSet(dsDirtyRooms, dsDirtyRooms.Tables[0].TableName, null, commandUpdate, null, UpdateBehavior.Transactional);

            return true;
        }